![588_Database.jpg](https://secure.tutorsglobe.com/CMSImages/588_Database.jpg)
Question : Complete complete the following Query tasks:
1. What are the Invoice and Sales Person for customer "Lcs Industries Inc."
2. What are the names and addresses of customers buying vanilla between 10/01/2017 to 12/31/2017
3. Calculate the total sales for each inventory item.
4. What are sales amount for each invoice? Based on the sales amount for each invoice, What are total sales amount for each employee?
5. What are the total sales for each customer?