Reference no: EM133246005
Using Northwind database Solve Basic Sql
1. Display orderID and the corresponding company name
2. Display the orderID, company name, and the employee name.
3. Fetch the maximum freight charge and the average freight charge of orders.
4. Display the number of customers in UK.
5. Display total revenue generated by employee ID 1. To obtain total revenue, multiply unitprice and quantity from orderdetails table.
6 Display the number of orders by each ShipCountry.
7. Display average price of products for each supplier ID.
8. Display number of customers per each ContactTitle.
9. Display total revenue for each productID.
10. Display employee id and number of orders against each employee for employees having at least 100 orders.
11. Display total revenue for each product from orderdetails table where total revenue of a product is greater than 10000.
12. Display number of customers in each country that have at most 10 customers.
13. Display the average unit price for every product from orderdetails table that have been ordered at least 30 times.
14. Display employee names and number of orders against each employee.
15. Display employee names and number of orders against each employee.