Question: SHOW SQL CODE WITH OUTPUT Question 7: 1. Consider the following table: Order_Detail Customer Orderno A001 A002 A003 A004 A005 Custno C003 C001 C005 C004

SHOW SQL CODE WITH OUTPUT

Question 7: 1. Consider the following table: Order_Detail Customer Orderno A001 A002 A003 A004 A005 Custno C003 C001 C005 C004 C001 Item Qty Amount Burger 3 60 Pizza 2 300 Burger 5 100 Burger 5 100 Hot- 2 40 dog Custno C001 C002 C003 name Address city Phone George | NV Delhi 6199408 Ashok Arawali Delhi 6129400 Raman DB Delhi 6133888 Road James Puna Delhi 6144218 Patrick Bihar Delhi | 6111228 C004 C005 a) Write a query to display the number of customers who live in DELHI and have ordered for Burger. b) Write a query to display the details of the customer order whose name ends with 'k'. c) Write a procedure to get the Item as input and print the total quantity ordered

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

SHOW SQL CODE WITH OUTPUT Question 6: I 1. Consider the following table: Order_Detail Orderno Custno Item Qty Amount A001 C003 Burger 3 60 A002 C001 Pizza 2 300 A003 C005 Burger 5 100 A004 C004...

SHOW SQL CODE WITH OUTPUT Question 12: 1. Consider the following table: Column Name BusNo Origin Destination Rate Kilometer Start time Datatype NUMERIC VARCHAR VARCHAR DECIMAL NUMERIC NUMERIC Size 4...

SHOW SQL CODE WITH OUTPUT Question 5: 1. Consider the following schema and solve the queries Catalog Book Id Title Author Id Publisher Id Year Price Author Author Id Name City Country Order_Detail...

SHOW SQL CODE WITH OUTPUT take random data Question 4: 1. Consider the following schema and solve the queries Catalog Book Id Title Author Id Publisher Id Year Price Author Author Id Name City...

SHOW SQL CODE WITH OUTPUT Question 11: 1. Consider the following table: EMP (Empno, Ename, Employer, Hiredate, Deptno) DEPT (Deptno, Dname, Loc_Id) LOCATION(Loc_Id, City) a. For each employee display...

SHOW SQL CODE WITH OUTPUT Question 1: 11. Consider the following table Employee Empno Name Deptno Basic Hra Deduction Tax a. Get the number of rows in the employee table. b. Find the total pay for...

SHOW SQL CODE WITH OUTPUT Question 9: 1. Consider the following tables: EMP (EMPNO, ENAME, JOB, SAL, DEPTNO, HOURS_WORKED) DEPT (DEPTNO, DNAME) a) Consider an employee can work in more than 1...

Select a state that contains at least 3 Dillards stores and provide a solution for each request below using Microsoft SQL Server Management Studio . Provide a screenshot for each solution, with the...

Select one Dillard's store.Using Microsoft SQL Server Management Studio, answer the following questions and provide a screenshot for each.Each screenshot should show the SQL code, the output data,...

Select one Dillards store. Using Microsoft SQL Server Management Studio, answer the following questions and provide a screenshot for each. Each screenshot should show the SQL code, the output data,...

Dynasty Corporation just completed its third year of operations. It has the following financial information for the taxable year 2019, its third year: Gross Income Deductions Philippines P1,250,000...

On January 1, Pollison Energy Group, Inc. acquired an oil processing plant at a total cost of $ 13,560,000, and paid cash. The estimated cost ( in todays market) to dismantle the plant and restore...

Eagle borrows $ 3 2 , 0 0 0 cash by signing a four - year, 9 % installment note. Record the issuance of the note on January 1 , 2 0 2 1 .

Under the Revised Uniform Principal and Income Act, gains or losses incurred on investments that occur after the death of the decedent a. are considered to be income of the estate. b. are included in...

=+e-learning in the MNE? Can training programs be developed in various locations and made available to everyone? What are the effects of the various options?

=+training programs be exported from headquarters or should overseas employees be brought to centralized or regional training facilities? How effective is

=+to successfully complete their assignments and develop an effective global management team.