Question: Given these two separate tables, please use one and only one SQL statement to get the results that List the ID, name and average unit

Given these two separate tables, please use one and only one SQL statement to get the results that List the ID, name and average unit cost of the products that have multiple suppliers, sorted by the number of suppliers in descending order.

Here is the picture of the data. Table to the left is a Product table and the table on the right is the Supplier table.Given these two separate tables, please use one and only one SQL

30 40 20 20 40 20 80 40 10 60 90 40 30 30 70 40 30 40 30 30 30 30 40 10 60 40 40 40 50 20 0123456789 17 67 74 88 32 2 700 283 200 600 30 8 1 300 44 400 150 esp 23 50 5 1 50 5 2 1 60 80 82 .00 12 14 15 15 80 4671 442 3 3 3 0 1 30570040 0123456789 Cat 351131135555555555225225554441 0123456789 00 00 75 00 00 00 00 .00 .00 00 3. 2. N 0062 30 8 2 30 4 85 50 5 1 50 5 2 1 60 283 Rec Sat Sec 0123456789

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!