SA235: IT & the Intelligent Enterprise SQL Review Assignment – Data Access & Bus

WRITE MY ESSAY

SA235: IT & the Intelligent Enterprise
SQL Review Assignment – Data Access & Business Decisions: SQL and Northwinds
REQUIRED: 
For each of the questions below, use our Oracle server and the Northwinds database to write SQL queries to help find the answer. Create a word document (or use the notepad app) to that includes all of your SQL used to answer each question and a copy (partial if appropriate) of the results of your queries (cut and paste). Include a short explanation if the results are not clear. This data model represents a database on our Oracle server called “Northwinds”. So, the “customers” table is “Northwinds.customers” on the server.  If you want to know how to create and access the Oracle server, please see the links at the bottom of this page. The SQL tutorial materials (in particular, SQL-WarmUp-Tutorial.pptx
) are also included to help you complete this assignment.   
Replace the ids in the same report with the company name and employee name.
Show how many shipments went to each of the two locations in each year.
Show how many shipments to each location in each year and the average freight cost by year. Order by location and year.
Show the total sales amount for each order and contact name for the company placing the order.
List all suppliers (by name) that supply more than 3 products. Include the number of products and order the list in alphabetical order by company name.
How much did each customer buy (in dollars) in 2020? (display the company name and sort from most to least).

WRITE MY ESSAY