Suppliens The Northwind Traders database contains sales data for a fictitious company called Northwind Traders, which imports Products 7 Pedu t0 Companym and exports specialty foods from around the...

Please solve questions in screenshot

Extracted text: Suppliens The Northwind Traders database contains sales data for a fictitious company called Northwind Traders, which imports Products 7 Pedu t0 Companym and exports specialty foods from around the world and resales their products to restaurants and other retailers. A database diagram is provided below. Padfe Cantademe Order Details Spper CantadTie 7 Pratuc Instructions: Write SQL queries that will provide the answers to the following questions. Quntiyerhit City Unihice gan Quantity Modify this document by pasting in an image Lhinak Post Cade O BSELECT Dn Cantry of your SQL Query after each question it FROM Bowlers ndertl Phane answers. Make sure you clearly show all the Chaninund SQL (wrap long lines to a new line) and the results that are generated like in the Hama example at the right. e The number of rows in the bottom right de e t taea NAL o tte Te Categories ? Cap corner should be clearly visible and at least Fa te AL tav the first 10 results rows. he Se N Sete a Caegonyeme Pe Fo N HAL Dception tat F Turn your modified Word document into Spte HAL aa Se te AL D2L. avet Ende MA RA e LAO t Reaion 1. From the Products table, list the name of each discontinued product and the total value of the inventory of that Igannerption product that we currently have on hand and give it an appropriate column name. Only list discontinued products and only list them if the total inventory value is greater than zero. Show your list with the highest inventory value first. Customes 7 Cuatamr Campnym EmploveeTomitories 7 Employe 7 Tenitay Contae • Discontinued products are determined by the Discontinued column value (0 = Active, 1 = Discontinued) The total value of inventory we have on hand is calculated by (UoitPrice * UnitsinStock) Cantadlie Adtra City Territories Orders Teritary Igan 2. From the Products table, list the CategocR and the total number of different products of that category that have not been discontinued (Discontinued = 0). Provide an appropriate column name for the total number of products and sort your list with the category with the fewest products first. PostaCade Temitaryrption Ciatiamer Cantry mploo Cer O Employ ees 7 Emplayeo 3. From the Orders table, list the Custemede and the total amount of money that customer spent on Freight for Lant Shppde Shp their orders that were shipped in 2019. The Freight column holds the Freight Cost for each order. Only list Finte Tie Inight customers who spent at least $2,000 on freight that year. Sort your list by GustomedD. Tikay Shpe hpAtdara 4. On the Employees table, list the name of each country where the employees live and the number of employees who live in that country. Hite Shpity GustomerCustomerDemo Adda Shpan * CuatamwtD Shpatka 7 CuatiamerlypD City Shplauniy 5. Using the QoderDetails table, list the ProductID, the total number of orders that product was included in, and the maximum discount amount on any order of that product. Provide appropriate column names for the number of orders and maximum discount amount. Only include products where the Maximum Discount Igan PatCade Cantry Hamhe Amount for that product was greater than $1,000. Exmion Phot GustomerDemoaraphics Hint: 7 Cuatamer y Nat Shippes • The total price before discount is the quantity multiplied by the unit price. The discount is a decimal value. For example, it may be .15 to mean a 15% discount rate. Cuatomern Iepartla Photh Campanym The discount amount is the total price before discount multiplied by the discount.