What is the microsoft access version of this answers? The book is Database Syste

Question

What is the microsoft access version of this answers?

The book is Database Systems Design, Implemenatation, & Management 11th Edition

The database file name is Ch07_LargeCo

The book companion website is down below.

http://www.cengage.com/cgi-wadsworth/course_products_wp.pl?fid=M20b&product_isbn_issn=9781285196145&token=

23. The Binder Prime Company wants to recognize the employee who sold the most of their 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, 2013, and December 5, 2013. If there is a tie for most units sold, sort the output by employee last name FIGURE Employees with the most Binder Prime units sold P8.23 Emp Num Emp FName Emp LName Emp Email Tota 84134 ROSALIE GARLAND G ROSALI98@LGCOMPANY.coM 23 83850 RUSTY IMLES RUSTY 95@LGCOMPANY.COM 23

Explanation / Answer

since the table structure is not defined so assuming the product selling date will be saved in column selling_date for the atble Employee.

select Emp_Num, Emp_FName, Emp_LName, Emp_Email, count(*) as Total from from Employees where selling_date between '#1/11/2013#' and '#5/12/2013#' and Product_name = 'Binder Prime' order by Total,Emp_LName

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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