(Solved): Use SQLite to write queries for the following questions Write a query that returns order IDs and ord ...

Write a query that returns order IDs and order date for orders placed by customers from Western Europe region(Hint: check subquery slides) Question 2 Write a query that returns the number or products for each supplier, display count and supplier company name. (Hint: check join examples, you need to use aggregate function COUNT and the GROUP BY clause) Question 3 What order has the largest quantity of items? (Hint: use subquery, COUNT and MAX) Question 4 Write a query that returns the last name and the title of Robert King's manager. (Hint: Check the Self-join slides.) Question 5 Write a query that returns the Contact Name and total orders price for all orders placed by each customer, return results sorted by Contact Name. (Hint: Join 3 tables, must return 89 lines.) Question 6 Write a query that returns the product name and supplier Company Name for the cheapest product and product name and supplier Company Name for the most expensive product (Hint: Check the Union Slides.) How much money did customer HANAR spend on all orders? Hint: calculation must take into account orde discounts. 0,15 - mean15\% discount. Question 8 How much money did each consumer spend on orders? (Hint: Try to modify your answer to question 7 to generalize it to show the results for all customers.)