write sql statement based on the attached ERD. List the supplier ID, food description, and total quantity

write sql statement based on the attached ERD.  

Transcribed Image Text:

List the supplier ID, food description, and total quantity (Hint: Use SUM) for each supplied food item. If the food item has never been purchased, still list the supplier ID and description. Group by supplier ID and description. Sort by Description. A) Use LEFT JOIN The relationship includes a composite primary key connection in the FROM clause. 35 rows selected List the supplier ID, food description, and total quantity (Hint: Use SUM) for each supplied food item. If the food item has never been purchased, still list the supplier ID and description. Group by supplier ID and description. Sort by Description. A) Use LEFT JOIN The relationship includes a composite primary key connection in the FROM clause. 35 rows selected

Answer rating: 100% (QA)

Given the ERD you want to list the supplier ID food description and total quantity even if the food item has never been purchased To achieve this you ... View the full answer