Question: For the database schema shown in the diagram below: Write SQL queries to: Get the supplier names ( Contact names ) and the total number

For the database schema shown in the diagram below:
Write SQL queries to:
Get the supplier names (Contact names) and the total number of supplied products for each
supplier, for only those suppliers that supplied more than 3 products. Give suitable name(s)
for any unnamed displayed column(s)
For all customers with at least 4 orders after 2021, get the customer id, total number of
orders, the last order date and the average unit price for products in his/her orders . Give
suitable name(s) for any unnamed displayed column(s). Display the result starting from
customers with the highest number of orders.
 For the database schema shown in the diagram below: Write SQL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!