Slip 20 - D) Consider the above tables and execute the following queries: 1. Display wholesaler from 'Pune' city and supplying 'Monitor'. 2. Display total number of wholesaler of each product. 3. Display all wholesalers who are supplying ‘Keyboard’ with maximum price. 4. Display total quantity of each product sold by ‘Mr. Khabia’. 5. Decrement rate of all products by 5% supplied by wholesaler from 'Pune ' city.

Solution:

Post a Comment

0 Comments