1.Display the state code, and number of orders shipped to it.For every stat with more than two orders. Sort the results on thenumber of orders in descending order.
2.Display the title and publisher name for all books that aremore expensive than the average retail price of books in thecomputer category. Sort the results by the title in alphabeticalorder.
3.Display the category, title, and retail price of books thatare more expensive than the average for their category. sort theresults by category, followed by title, in alphabetical order.
Answer