80.2K

Verified Solution

Link Copied!

BSAN 535: Databases and Big Data for Analysis Spring B 2022 8. Write a query to display the employee number, first name, last name, brand name, and total units sold for each brand by that employee. Sort the results by employee number. The column labels and first few rows of your output must match the figure below. EMPLOYEE_ID EMP_FNAME EMP_LNAME BRAND NAME Total Units Sold 83509 FRANKLYN STOVER BINDER PRIME 48 83509 FRANKLYN STOVER BUSTERS 38 83509 FRANKLYN STOVER FORESTERS BEST 42 83509 FRANKLYN STOVER HOME COMFORT 67 83509 FRANKLYN STOVER LE MODE 96 83509 FRANKLYN STOVER LONG HAUL 76 83509 FRANKLYN STOVER OLDE TYME QUALITY 69 83509 FRANKLYN STOVER STUTTENFURST 66 83509 FRANKLYN STOVER VALU-MATTE 33 83537 CLEO ENGLISH BINDER PRIME 106 83537 CLEO ENGLISH BUSTERS 84 83537 CLEO ENGLISH FORESTERS BEST 64 83537 CLEO ENGLISH HOME COMFORT 148 BSAN 535: Databases and Big Data for Analysis Spring B 2022 8. Write a query to display the employee number, first name, last name, brand name, and total units sold for each brand by that employee. Sort the results by employee number. The column labels and first few rows of your output must match the figure below. EMPLOYEE_ID EMP_FNAME EMP_LNAME BRAND NAME Total Units Sold 83509 FRANKLYN STOVER BINDER PRIME 48 83509 FRANKLYN STOVER BUSTERS 38 83509 FRANKLYN STOVER FORESTERS BEST 42 83509 FRANKLYN STOVER HOME COMFORT 67 83509 FRANKLYN STOVER LE MODE 96 83509 FRANKLYN STOVER LONG HAUL 76 83509 FRANKLYN STOVER OLDE TYME QUALITY 69 83509 FRANKLYN STOVER STUTTENFURST 66 83509 FRANKLYN STOVER VALU-MATTE 33 83537 CLEO ENGLISH BINDER PRIME 106 83537 CLEO ENGLISH BUSTERS 84 83537 CLEO ENGLISH FORESTERS BEST 64 83537 CLEO ENGLISH HOME COMFORT 148

Answer & Explanation Solved by verified expert

See Answer