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.
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
Get step-by-step solutions from verified subject matter experts
