Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started