Write a query to display the number of products within each base and type combination, sorted by the base and then by type (Figure P7.36).

  

Transcribed Image Text:

FIGURE P7.27 THE CH07_LARGECO ERD LGCUSTOMER LGBRAND PK Cust Code PK Brand ID Cust Fname Cust Lname Cust_Street Cust City Cust State Cust ZIP Cust Balance Brand Name Brand_Type inclddes places LGPRODUCT LGLINE PK Prod SKU LGINVOICE PK,FK1 Inv Num Prod Descript Prod_Type Prod_Base Prod Category Prod Price Prod_QOH Prod_Min FK1 Brand ID PK Inv Num PK Line Num appears on contains FK1 Cust Code Inv Date Inv_Total FK2 Employee_ID Prod_SKU Line Qty Line_Price FK2 completes provided by LGEMPLOYEE PK Emp Num LGSALARY_HISTORY LGSUPPLIES Emp Fname Emp Lname Emp Email Emp_Phone Emp_Hiredate Emp_Title Emp Comm FK1 Dept_Num PK,FK1 Emp Num +PK PK,FK1 Vend ID PK,FK2 Prod SKU has Sal From Sal End Sal_Amount provides empoys mankges LGVENDOR PK Vend ID LGDEPARTMENT Vend_Name Vend Street Vend City Vend State Vend ZIP PK Dept Num Dept Name Dept_Mail_Box Dept Phone FK1 Emp_Num FIGURE P7.27 THE CH07_LARGECO ERD LGCUSTOMER LGBRAND PK Cust Code PK Brand ID Cust Fname Cust Lname Cust_Street Cust City Cust State Cust ZIP Cust Balance Brand Name Brand_Type inclddes places LGPRODUCT LGLINE PK Prod SKU LGINVOICE PK,FK1 Inv Num Prod Descript Prod_Type Prod_Base Prod Category Prod Price Prod_QOH Prod_Min FK1 Brand ID PK Inv Num PK Line Num appears on contains FK1 Cust Code Inv Date Inv_Total FK2 Employee_ID Prod_SKU Line Qty Line_Price FK2 completes provided by LGEMPLOYEE PK Emp Num LGSALARY_HISTORY LGSUPPLIES Emp Fname Emp Lname Emp Email Emp_Phone Emp_Hiredate Emp_Title Emp Comm FK1 Dept_Num PK,FK1 Emp Num +PK PK,FK1 Vend ID PK,FK2 Prod SKU has Sal From Sal End Sal_Amount provides empoys mankges LGVENDOR PK Vend ID LGDEPARTMENT Vend_Name Vend Street Vend City Vend State Vend ZIP PK Dept Num Dept Name Dept_Mail_Box Dept Phone FK1 Emp_Num

Answer rating: 100% (QA)

Query SELECT PRODBASE PRODTYPE COUNTPRODSKU FROM LG PRODUCT GROUP BY ... View the full answer