The Binder Prime Company wants to recognize the employee who sold the most of its products during a specified period. Write a query to display the employee number, employee first name, employee last name, email address, and total units sold for the employee who sold the most Binder Prime brand products between November 1, 2017, and December 5, 2017. If there is a tie for most units sold, sort the output by employee last name.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

The Binder Prime Company wants to recognize the employee who sold the most of its products during a specified period. Write a query to display the employee number, employee first name, employee last name, email address, and total units sold for the employee who sold the most Binder Prime brand products between November 1, 2017, and December 5, 2017. If there is a tie for most units sold, sort the output by employee last name.

 

 

EMP NUM
EMP FNAME
EMP LNAME
EMP_EMAIL
ТОTAL
84134
ROSALIE
GARLAND
G.ROSALI98@LGCOMPANY.COM
23
83850
RUSTY
MILES
M.RUSTY95@LGCOMPANY.COM
23
Transcribed Image Text:EMP NUM EMP FNAME EMP LNAME EMP_EMAIL ТОTAL 84134 ROSALIE GARLAND G.ROSALI98@LGCOMPANY.COM 23 83850 RUSTY MILES M.RUSTY95@LGCOMPANY.COM 23
FIGURE P7.27 THE CHO7_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
includes
places
LGPRODUCT
LGLINE
PK
Prod SKU
LGINVOICE
PK,FK1 Inv_Num
Line Num
Prod_Descript
Prod_Type
Prod_Base
Prod_Category
Prod_Price
Prod_QOH
Prod_Min
FK1 Brand_ID
PK Inv Num
PK
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
employs
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
Transcribed Image Text:FIGURE P7.27 THE CHO7_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 includes places LGPRODUCT LGLINE PK Prod SKU LGINVOICE PK,FK1 Inv_Num Line Num Prod_Descript Prod_Type Prod_Base Prod_Category Prod_Price Prod_QOH Prod_Min FK1 Brand_ID PK Inv Num PK 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 employs 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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Single Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education