List supplier id, name, and city of any supplied food with its price is more than...
Fantastic news! We've Found the answer you've been seeking!
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 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 ssupplierid sname scity ... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these databases questions
-
Now, consider the situation described in the figure below where the battery that charged the top and bottom plates of the capacitor remains connected. As in Question #3, assume that the distance d...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
1.In a general partnership, a partners interest in specific partnership property is subject to a partners liability for alimony not transferable voluntarily or involuntarily transferable for a...
-
In an organization that has high employee satisfaction, ______. Multiple choice question. customer interactions are forced and scarce employee turnover is high more positive interactions take place...
-
Do tides occur in the molten interior of Earth for the same reason that tides occur in the oceans?
-
How does the average annual precipitation differ around the world? The data in AnnualPrecipitation contains the average annual precipitation data in millimeters for 4,166 weather stations. a....
-
What are three ways in which you can receive income from your mutual fund investments?
-
On January 1, 2014, Alicia Masingale established Leopard Realty, which completed the following transactions during the month: a. Alicia Masingale transferred cash from a personal bank account to an...
-
The one-year interest rate over the next eight years will be 4.099%, 5.5%, 6%, 8.5%, 10%, 11.5%, 14%, and 15.5%. Using the expectations theory, what will be the interest rates on an eight-year bond?...
-
Find the court decision located at 67 AFTR2d 91-718. a. Which court heard the case? b. Who was the judge(s)? c. Which tax year(s) is in question and in what year was the case decided? d. Which Code...
-
I need help solving this. I will message link for you all to open data in excel. The data info i had sent the link to have access to it
-
A situation analysis is a detailed description of a brand's current marketing situation. A SWOT analysis draws upon facts contained in the situation analysis to determine the strengths, weaknesses,...
-
What are the two main approaches for networking? Distinguish between the fundamental features of these approaches? Which networking approach is mainly used for the Internet? Why? What are access...
-
PCPurchase Research Using the background information below, research a PC purchase meeting all HFA Associates' requirement sat the best price: Purchase of 50 new PCs to replace all existing employee...
-
Since January 1 , 2 0 2 0 , John and Mary Company provide sales and services for bike riders. It shows the following balances where all have normal balances: Cash $ 3 8 5 0 0 Accounts Receivable $ 5...
-
a) Discuss how materiality affects audit reporting decisions. (5 marks) The final audit of ABC Limited is near completion. The engagement team is satisfied that legal claims received to date have...
-
We used the obtained data for NVIDIA Corporation (NVDA) and computed the variance and the standard deviation of the monthly returns from 3/1/1999 to 10/1/2023 = 17.859% What do you think of this...
-
What are the three kinds of research types? Explain each type.
-
Why is local control of data an advantage in a distributed database?
-
Suppose in addition to the requirements specified in Question 7, you must store the number of the department in which the student is majoring. Indicate the changes this would cause in the design in...
-
Answer each of the following questions using the TAL Distributors data shown in Figure 1-5. No computer work is required. 1. List the names of all customers that have a credit limit that is less than...
-
The following trial balance was extracted from the books of A Scholes at the close of business on 28 February 19X7. Notes: (a) Stock 28 February 19X7 3,510. (b) Wages and salaries accrued at 28...
-
Express the vector \(\mathbf{v}=(1,2,3)\) as a linear combination of the vectors \(\mathbf{a}_{1}=(1,1,1), \mathbf{a}_{2}=(1,0,-2)\), and \(\mathbf{a}_{3}=(2,1,0)\).
-
T Morgan, a sole trader, extracted the following trial balance from his books at the close of business on 31 March 19X9: Notes: a) Stock 31 March 19X9 4,290. b) Wages and salaries accrued at 31 March...
Study smarter with the SolutionInn App