List supplier id, name, and city of any supplied food with its price is more than...

   

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 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

Answer rating: 100% (QA)

Answer The code is as follow SELECT ssupplierid sname scity ... View the full answer