please provide me some complex queries using joins and sub queries and self join and corelated query and using some funtions.