====== Exercise 4 - SQL Basics 3 ====== 1 | Select all products with product categories and include also products without the category. Product name and its category name should be presented in the result set. -------------------------------------------------- -------------------------------------------------- ################################################## 2 | Select products that have never been ordered. Include product name in the result set. -------------------------------------------------- -------------------------------------------------- ################################################## 3 | Count how many orders each shipper has delivered. Show shipper name and count in the result set. Use column name shipped_orders for the calculated column. -------------------------------------------------- -------------------------------------------------- ################################################## 4 | List categories with 10 or more products. Show category name and product count in the result set. Order the result set by product count in descending order. -------------------------------------------------- -------------------------------------------------- ################################################## 5 | Calculate how many products each customer have ordered (sum quantities). Use column name total_bought for the calculated column. In addition to this column show customers name in the result set. -------------------------------------------------- -------------------------------------------------- ################################################## 6 | List products with price greater or equal than all products with product name starting with letter Q. Include productID, product name and price in the result set. Order the result set by price in descending order. -------------------------------------------------- -------------------------------------------------- ################################################## 7 | Use UNION to gather the following customers: - Customers coming from Argentina or Brazil - Customers who have made at least one order in 17th of August 2023 Show customer name in the result set and order the result set by customer name in ascending order. -------------------------------------------------- -------------------------------------------------- ################################################## 8 | Calculate the total price (quantity*price) for products in the following orderIDs: 10250, 10260, 10270 and 10280. Use column name total_price for the calculated column. In addition to this column, show product name in the result set. -------------------------------------------------- -------------------------------------------------- ################################################## 9 | Use UNION to gather the following suppliers: - Suppliers having five or more products - Suppliers with postal code length five or less and country is Japan - Suppliers offering products in seafood and dairy products categories Show supplier name, contact name and phone number in the result set. Order the result set by supplier name in ascending order. -------------------------------------------------- -------------------------------------------------- ################################################## 10 | List customers who have bought the most popular product (most sold). Include customer name and quantity in the result set and order the result set by quantity in descending order. -------------------------------------------------- --------------------------------------------------