Reference no: EM133265503

USE NORTHWIND Database in SQL

1. Create a query that shows the order ids and the associated Customer names for orders. List only customers from Northern and Western CA, BC, and MT Regions Tables: Orders, Customers*/

2. Create a query that shows the total number of orders by Customer, query must include the count of order, company name, and country. Filter all customers with order count above 25 orders */

3. Write a query to list orderid, companyname and the ordertotal (which is unit price and quantity from order details table) you need to identify all the orders, and company names where order sum is between 15000 and 20000 value*/r