List supplier id, name, and city of any supplied food with its price is more than a nested query…

List supplier id, name, and city of any supplied food with its price is more than a nested query…

Question:

   

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
FOOD
PF* supplier_id
P
product_code
menu_item
description
price
price_upcharge
FOOD SUPPLIER
* supplier_id
supplier_name
supplier_city
IP item_number
PF* lunch_id
F ” supplier_id
F
M
LUNCH_ITEM
X
product_code
quantity
DEPARTMENT
dept_code
department_name
HI

HH
P lunch_id
F
F
LUNCH
X
lunch date
worker_id
WORKER
worker_id
first_name
last_name
city
hire_date
credit_limit
phone_number
manager_id
dept_code

Expert Answer:

Answer rating: 100% (QA)

Answer The code is as follow SELECT s supplier id s name s ci
View the full answer