Question
7) What are the total amount of shoes sold to customers located in each State in Canada? The result should consist of two columns showing
7) What are the total amount of shoes sold to customers located in each State in Canada? The result should consist of two columns showing the list of State (called Province) along with the total sales figures organized from the highest to the lowest. The Total sales figures can be calculated by multiplying the Quantity to SalePrice. Name this column CanadaSales.
8) Create a sales report showing Total Sales by Manufacturer during the last quarter of 2015. Name the columns Manufacturer and TotalSales. Show the rerults by TotalSales from high to low.
10) Show Employee's LastName and FirstName whose Maximum work hours is between 30 and 35 hours per week. Must use BETWEEN and subquery in the WHERE clause.
11) What is the average of all the sales made in April 2014? Round your answer to two decimal points. Use a subquery in the FROM clause. The subquery should add up the amounts for the saleitems for each sale.
I really need help with these questions, I would like to add that i am working On SQL in Oracle.
Thanks
Customer Customer FirstName LastName StreetAddress CITY State Postal Code Country Phone Sale Sale SaleDate Customer Tax Shipping Salettem Sale Products Items Quantity Sale Price Product Product Product Name Manufacturer Composition ListPrice Gender Category Color Description Manufacturer Manufacturer ManufacturerName Address Address2 City State PostalCode Phone Employee Employee Frame LastName Address City SUM ZIP Phone Manager SSN Salary Employee Employee Salary Coact URL: WageEmployee Employee Wage Max Hours HireDate Customer Customer FirstName LastName StreetAddress CITY State Postal Code Country Phone Sale Sale SaleDate Customer Tax Shipping Salettem Sale Products Items Quantity Sale Price Product Product Product Name Manufacturer Composition ListPrice Gender Category Color Description Manufacturer Manufacturer ManufacturerName Address Address2 City State PostalCode Phone Employee Employee Frame LastName Address City SUM ZIP Phone Manager SSN Salary Employee Employee Salary Coact URL: WageEmployee Employee Wage Max Hours HireDate
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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