PLEASE SOLVE IN SQLITE BROWSER AND ATTACH SCREENSHOTS THANKYOU

EXPLANANTION IS NO HELP

In the SQLite Browser, you need to write, save, and run the following SQL queries:

2.1. Open the AppliedProject2.db database and save it as a project.

2.2. Create and run the queries to create primary and foreign keys. Save the queries in the project.

2.3. Insert a new customer. The record must contain your full name as a CustomerName, your state where you currently live (VIC, NSW), your APIC email address as a CustomerEmail.

2.4. Create a new sale fact related to the new customer. You can choose any existing product, warehouse, date and sales office. 2.5. Display all customer names, their addresses and states. 2.6. Display all customer names from NSW. 2.7. Display the total amount of sales for all companies in 2018. 2.8. Display total amount of sales for each customer separately. 2.9. Display total amount of sales for each product and state separately, i.e. the output should contain 3 columns: product, state and total amount for this product and state. 2.10. Display products sold from warehouses located in QLD. 2.11. For each sale, display a customer name and a purchase date. 2.12. Display a total number of sales (NOT AMOUNT!) for each customer. 2.13. For each sales office (branch), display: branchKey, branch state, a customer name (a customer purchased in this office), a product name purchased by this customer, and a month number of the purchase. 2.14. Calculate a number (not amount !) of sales in the first quarter of 2016. 2.15. Display the following sale information: Office branchAddress, customerName, productName, WarehouseDivision, SaleDate for all offices in Victoria and between 15 June 2017 and 15 October 2017.