62) Write a query to display the largest average product price of any brand. 63)

Question

62) Write a query to display the largest average product price of any brand.

63) Write a query to display the brand ID, Brand name, brand type, and average price of products for he brand that has the largest average product price.

64.) Write a query to display the manger name, department name, epartment phone number, employee name, customer name, invoice date, and invoice totalfor the department manager of the emploee who made a sale to a customer whose last name is Hagan on May 18, 2013. For all person names, concatenate the first and last names into a single field.

Explanation / Answer

62-select Max(average Product Price ) from Tablename where brand="brandname" ;

63-select brandid,brandname,brandtype,averageprice from tablename where averageproductprice="(select Max(average Product Price ) from Tablename)";

64-select managername,departementname,epartement phoe number,employee name,customet name,invoice date,invoice totalfor from departement manager table where lastname="Hagan" and invoice date="2013-05-13";

Related Questions

Navigate

• Browse (All)
• Browse 6
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.