SQL

QUIZ

Please review provided ERD for Sales in ****database.

Only Assumptions :

Total order quantity is: sum(quantityOrdered ) as Qty,

TotalAmount is: sum(priceEach*quantityOrdered) as total

construct SQL statement joining all necessary tables, RUN it and choose correct result.

EXAMPLE of possible sql to find TotalAmount for officeCode = 1 :

select sum(od.priceEach * od.quantityOrdered) as total , of.officeCode

from yhelen.orders o join yhelen.orderdetails od on o.orderNumber = od.orderNumber 

join yhelen.products p on p.productCode = od.productCode join 

yhelen.customers c on c.customerNumber = o.customerNumber join

 yhelen.employees e on e.employeeNumber = c.salesRepEmployeeNumber join

 yhelen.offices of on of.officeCode = e.officeCode 

group by 2

Save time and excel in your essays and homework. Hire an essay writer for the best price for the top-notch grade you deserve.
275 words per page

You essay will be 275 words per page. Tell your writer how many words you need, or the pages.

12 pt Times New Roman

Unless otherwise stated, we use 12pt Arial/Times New Roman as the font for your paper.

Double line spacing

Your essay will have double spaced text. View our sample essays.

Any citation style

APA, MLA, Chicago/Turabian, Harvard, our writers are experts at formatting.

We Accept
Image 3