Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In the XAMPP MySQL, you need to write, save, and run the following SQL queries: o Run the provided script to create the database
In the XAMPP MySQL, you need to write, save, and run the following SQL queries: o Run the provided script to create the database Insert a new product. o Create a new sale fact related to the new product. You can choose any existing customer, warehouse, date and sales office. For all company branches (Company Dim table) display branch addresses, emails and states. o Display all customer names from Queensland. Display the total amount of sales for all companies in 2016. Display total amount of sales for each company branch separately. o 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. o Display products sold from warehouses located in New South Wales. O For each sale, display a customer name and a purchase date. o Display a total number of sales (NOT AMOUNT in $) for each customer. For each sales office (branch), display: branch Key, 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. o Calculate a number (not amount in $) of sales in the second quarter of 2018. Display the following sale information: Office branchAddress, customerName, productName, Warehouse Division, SaleDate for all offices in Victoria and between 20 January 2017 and 15 May 2017.
Step by Step Solution
★★★★★
3.44 Rating (151 Votes )
There are 3 Steps involved in it
Step: 1
Answer To perform the tasks youve listed youll need to write and execute SQL queries in XAMPPs MySQL Here are the queries for each task 1 Run the prov...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started