List supplier id, name, and city of any supplied food with its price is more than a nested query…
Transcribed Image Text:
List supplier id, name, and city of any supplied food with its price is more than
a nested query to find food items in the FOOD table that the price are more than
Use a subquery or also called a nested query
FOOD SUPPLIER (and FOOD table inside of the subquery)
5 rows selected Question 6. A) Count the number of lunches per lunch date purchased by workers who are not
assigned to any department and hired between December 01, 2012, and April 01 2020.
Format the lunch date in the fmMONTH-YYYY format.
□ Use an inner join to obtain this result
☐ WORKER and LUNCH tables
Label the lunch date as LD and the count as LUNCH_COUNT
Group by the non-aggregated column in the SELECT clause
□ Sort by LD.
2 rows selected.
B) Expand on 6A: Add a clause to remove any LD with a total lunch count greater than 2.
1 row selected. Lunches DB ERD
F ” supplier_id
Answer rating: 100% (QA)
Answer The code is as follow SELECT s supplier id s name s ci
View the full answer