SQL Northwind Database Query Question

Question

This question was closed Mar 12, 2017 at 09:26 AM by ThomasRushton for the following reason: Other

Question by Amanda · Mar 04, 2010 at 07:01 PM · sub-query

SQL Northwind Database Query Question

For each employee, his/her last name and first name, the product name of the product that is present most times in orders processed by him/her, and the number of orders in which it appears. Don’t care about ties (i.e. more than one row for each employee is allowed)

0

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2017-03-12T06:45:58Z

Answer by Shohel · Mar 12, 2017 at 06:45 AM

What was the total unit sold and total sales before a discount From product and order Details table

0 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2010-03-04T23:56:34Z

Answer by Squirrel 1 · Mar 04, 2010 at 11:56 PM

We will not do your assignment for you.

Try it yourself and if you have problem, post your query and we will be very happy to advice you accordingly.

0 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

SQL Northwind Database Query Question

2 Replies

Follow this Question

Related Questions