Thanks you guys. All the solutions work. I'm sorry for not following rules and posting the DDL statements. I'll keep this in mind when I post next time.

Sorry if I have caused any inconvenience.