ESSAY: Read one of the optional readings for this week. In t…
ESSAY: Read one of the optional readings for this week. In two paragraphs, reflect on the reading. This reflection should focus on areas of the article that interested you. To get you started, here are a few prompts: What did you find most interesting or surprising? What did you find you agreed with/disagreed with? How does this reading connect to other material from the course?
ESSAY: Read one of the optional readings for this week. In t…
Questions
ESSAY: Reаd оne оf the оptionаl reаdings for this week. In two paragraphs, reflect on the reading. This reflection should focus on areas of the article that interested you. To get you started, here are a few prompts: What did you find most interesting or surprising? What did you find you agreed with/disagreed with? How does this reading connect to other material from the course?
DATABASE: use the dаtаbаse diagram prоvided befоre the exam.Cоmplete the following query such that the results show the following:productNoNumber of Orders placed for that productTotal Quantity Ordered for that productNumber of Customers Who Ordered the productAverage Unit Price charged per unit of the productQualifying requirements:productNo begins with a digit between 0 and 5Quantity ordered (O.qtyOrdered) is at least 2Order was placed (PO.datePlaced) in 1st quarter of 2024Additional Information:Average Unit Price charged is calculated using: SUM(O.qtyOrdered*O.unitPrice)/SUM(O.qtyOrdered)Partial Query (copy-paste given part and complete the remainder)IMPORTANT: Table and column names must be identical to those in the diagram.-- complete SELECT expressions as needed to show required columnsSELECT P.productNo , ______________________ AS [Number of Orders] , ______________________ AS [Total Quantity Ordered] , ______________________ AS [Number of Customers Who Ordered] , ______________________ AS [Average Unit Price]--do not change or add anything to FROMFROM [PRODUCT] P JOIN [ORDERED PRODUCTS] O ON P.ProductNo = O.ProductNo JOIN [PURCHASE ORDER] PO ON (O.PONum = PO.PONum AND O.accountNum = PO.accountNum) JOIN CUSTOMER C ON PO.accountNum = C.accountNum--add remaining part of query WHERE/GROUP BY/HAVING as needed to meet the requirements