20 People are following this question.
Write a sub-query that returns the total number of orders placed by the customer with the highest number of orders. Include the customerid and the number of orders placed
I am beginner in learning SQL and need some help in how to approach in creating queries in SQL? Would really appreciate help on the requests.
Using outer query tables in sub-query joins (defined in select clause)