[solved] – Question 82600

First of all go to https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all.
This is the link to W3Schools MySQL Tryit Editor
and the sample database we are using.

Questions:
1. Write a query that lists the first name and the number of sales of each
employee including the ones that has not received any orders yet.
2. Write a query that calculates and lists the total price of each order.
3. Write a query that lists the name of each different product shipped by
Speedy Express.

Expert Answer

---