Please solve questions in screenshot SuppliensThe Northwind Traders database contains sales data for a fictitious company called Northwind Traders, which importsProducts7 Pedut0Companymand exports specialty foods from around the world and resales their products to restaurants and other retailers. Adatabase diagram is provided below.PadfeCantademeOrder DetailsSpperCantadTie7 PratucInstructions: Write SQL queries that will provide the answers to the following questions.QuntiyerhitCityUnihiceganQuantityModify this document by pasting in an imageLhinakPost CadeOBSELECTDnCantryof your SQL Query after each questionitFROM BowlersndertlPhaneanswers. Make sure you clearly show all theChaninundSQL (wrap long lines to a new line) and theresults that are generated like in theHamaexample at the right.eThe number of rows in the bottom rightde e t taeaNALotte TeCategories? Capcorner should be clearly visible and at leastFa te ALtavthe first 10 results rows.he SeN Sete aCaegonyemePeFo N HALDceptiontat FTurn your modified Word document intoSpte HALaa SeteALD2L.avetEndeMARA e LAO tReaion1. From the Products table, list the name of each discontinued product and the total value of the inventory of thatIgannerptionproduct that we currently have on hand and give it an appropriate column name. Only list discontinuedproducts and only list them if the total inventory value is greater than zero. Show your list with the highestinventory value first.Customes7 CuatamrCampnymEmploveeTomitories7 Employe7 TenitayContae• 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)CantadlieAdtraCityTerritoriesOrdersTeritaryIgan2. From the Products table, list the CategocR and the total number of different products of that category thathave not been discontinued (Discontinued = 0). Provide an appropriate column name for the total number ofproducts and sort your list with the category with the fewest products first.PostaCadeTemitaryrptionCiatiamerCantrymplooCerO Employ ees7 Emplayeo3. From the Orders table, list the Custemede and the total amount of money that customer spent on Freight forLantShppdeShptheir orders that were shipped in 2019. The Freight column holds the Freight Cost for each order. Only listFinteTieInightcustomers who spent at least $2,000 on freight that year. Sort your list by GustomedD.TikayShpehpAtdara4.On the Employees table, list the name of each country where the employees live and the number of employeeswho live in that country.HiteShpityGustomerCustomerDemoAddaShpan* CuatamwtDShpatka7 CuatiamerlypDCityShplauniy5. Using the QoderDetails table, list the ProductID, the total number of orders that product was included in, andthe maximum discount amount on any order of that product. Provide appropriate column names for thenumber of orders and maximum discount amount. Only include products where the Maximum DiscountIganPatCadeCantryHamheAmount for that product was greater than $1,000.ExmionPhotGustomerDemoaraphicsHint:7 Cuatamer yNatShippes• 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.CuatomernIepartlaPhothCampanymThe discount amount is the total price before discount multiplied by the discount.

In screen short :- Database management system table is present in this screen short where one table…

Prodcts The Nectbuodoattadera database contains sales data for a fictitious company called Northwind Traders, which imports and exports specialty foods from around the world and resales their products to restaurants and other retailers. A Comp Co e database diagram is provided below. Order Detis Corteri A Instructions: Write SQL queries that will provide the answers to the following questions. Modify this document by pasting in an image of your SQL Query after each question it answers. Make sure you clearly show all the SQL (wrap long lines to a new line) and the results that are generated like in the example at the right. SELECT Caty FROM Bowlers The number of rows in the bottom right ategories corner should be clearly visible and at least the first 10 results rows. Turn your modified Word document into D2L. Reaion 1. From the Products table, list the name of each discontinued product and the total value of the inventory of that 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. • 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 * yoitslostock) Gustomen Caron EmoloveeTeritories Cot Cota A Territaries Orders lee le on 2. From the Products table, list the CatesondR 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. hae C Employees 3. From the Orders table, list the SustomerR and the total amount of money that customer spent on Freight for Le their orders that were shipped in 2019. The Freight column holds the Freight Cost for each order. Only list customers who spent at least $2,000 on freight that year. Sort your list by SustemeriD. sec 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. GustomeCuatomerDemo A 5. Using the QrderDetails table, list the ProdustiD, 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 Amount for that product was greater than $1,000. aae GustomeDemearaohics Hint: Shipen • 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. • The discount amount is the total price before discount multiplied by the discount. Cu nle