1. Answerer the following question with he reference of diagram given below
2. SQL query to return the 10 most recently shipped orders with freight costs less than 50. Remember to filter out null ShippedDates by using the IS NOT NULL keywords. (Hint: OrderID include 11067, 11069, etc.)
3. SQL query that shows the total number of orders for each customer in descending order. (Hint: CustomerID of SAVEA is on the top)
4. SQL query to determine the top 5 customers with the most orders after the year 1996. (Hint: went over in lab :)
5. SQL query to list the top 3 Employees that have the most total freight costs from all of the orders they worked on between Jan 31, 1996 and April 1, 1998. (Hint: Margaret Peacock)
6. SQL query to determine which product has the largest number of days between its first and most recent order. (Hint: Queso Cabrales/Tofu)
7. SQL query to determine which Category of Products had the most orders and the highest total freight cost in the year 1998. (Hint: Beverages)
8. SQL query to determine which DISTINCT Beverages were ordered in the year 1996 from suppliers based in the USA or UK. 
9.  

Transcribed Image Text:

categories 123 category_id ADC category_name ADC description picture order details 123 order_id 123 product_id 123 unit price 123 quantity 123 discount E customers noc customer_id ADC company name ADC contact name ADC contact title ADC address ADC City ac region ADC postal code noc country noc phone noc fax products 123 product_id noc product name 123 supplier_id 123 category_id ADC quantity_per_unit 123 unit price 123 units in stock 123 units_on_order 123 reorder_level 123 discontinued customer customer_demo noe customer_id ADC customer_type_id customer_demographics ADC customer_type_id ADC customer_desc suppliers 123 supplier_id ADC company name noc contact name ADC contact title ADC address Roc city ADC region ADC postal code ADC Country ADC phone noc fax ADC homepage Borders 123 order_id ADC customer_id 123 employee_id Ⓒorder_date required_date shipped_date 123 ship via 123 freight ABC ship name not ship address ADC ship city ADC ship region ADC Ship postal code ADC ship country employees 123 employee_id ABC last_name ABC first name Aoc title ADC title_of_courtesy birth date hire_date ADC address Asc city Asc region noc postal code not country ADC home phone not extension photo Aoc notes 123 reports to ADC photo path shippers 123 shipper_id ABC company name ase phone Bemployee_territories 123 employee_id noc territory_id 3 territories ABC territory_id ADC territory description 123 region_id region 123 region_id ADC region_description us_states 123 state_id noc state_name noc state abbr ADC state region categories 123 category_id ADC category_name ADC description picture order details 123 order_id 123 product_id 123 unit price 123 quantity 123 discount E customers noc customer_id ADC company name ADC contact name ADC contact title ADC address ADC City ac region ADC postal code noc country noc phone noc fax products 123 product_id noc product name 123 supplier_id 123 category_id ADC quantity_per_unit 123 unit price 123 units in stock 123 units_on_order 123 reorder_level 123 discontinued customer customer_demo noe customer_id ADC customer_type_id customer_demographics ADC customer_type_id ADC customer_desc suppliers 123 supplier_id ADC company name noc contact name ADC contact title ADC address Roc city ADC region ADC postal code ADC Country ADC phone noc fax ADC homepage Borders 123 order_id ADC customer_id 123 employee_id Ⓒorder_date required_date shipped_date 123 ship via 123 freight ABC ship name not ship address ADC ship city ADC ship region ADC Ship postal code ADC ship country employees 123 employee_id ABC last_name ABC first name Aoc title ADC title_of_courtesy birth date hire_date ADC address Asc city Asc region noc postal code not country ADC home phone not extension photo Aoc notes 123 reports to ADC photo path shippers 123 shipper_id ABC company name ase phone Bemployee_territories 123 employee_id noc territory_id 3 territories ABC territory_id ADC territory description 123 region_id region 123 region_id ADC region_description us_states 123 state_id noc state_name noc state abbr ADC state region

Answer rating: 100% (QA)

Given the database schema youve shown here are the SQL queries for each of the tasks youve described 1 SQL query to return the 10 most recently shipped orders with freight costs less than 50 Remember ... View the full answer