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)
Answer by Squirrel 1 ·
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.