Answer to Question #82600 in Databases | SQL | Oracle | MS Access for Anna

Question

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.

Answer 1

Dear Anna, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order