Answered step by step
Verified Expert Solution
Link Copied!

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David M. Kroenke, David J. Auer

7th edition

133544621, 133544626, 0-13-354462-1, 978-0133544626

More Books

Students also viewed these Databases questions

Question

How much of my product can I expect to sell?

Answered: 1 week ago

Question

Explore common areas of clinical focus in health psychology.

Answered: 1 week ago

Question

How do you create, save,and run an SQL script in MySQL?

Answered: 1 week ago