Use the NORTHWIND Diagram below to answer the following question:

Write a single SQL statement to create the results called for in the question.

Do not submit any results.

Formatting counts

1. NORTHWIND: Write a query to list each shipping company nameand the number of orders each shipped during January 2000

2.NORTHWIND: Write a query to list category name and the value of inventory in stock (UnitPrice* UnitsInStock) for all categories of products with more than $10,000 in inventory.

NorthWind Diagram Below

Products Order Details Column Name Condensed Conde, B OrderID int B ProductID ProductName nvarchar (40) oo ProductID int SupplierlD UnitPrice money CategoryID Quantity smalint Quantity PenUni nvarchar (20) UnitPrice UnitsInStock smaln UnitsOnOrde smallint Categories ReorderLevel smallint Column Name Condensed Discontinued Category ID CategoryName nvarchar (15) Description ntext Image Suppliers Column Name Condensed SupplierlD Territories CompanyName nvarchar(40) Column Name Condensed ContactName mvardhar (300 Territory ID nvarchar (20 ContactTite mvardhar(30 nchar (50) tory Description Address nvarchar (60) RegonID mvardhar (150 City mvardhar (15) Region PostalCod mvardhar (100 Country nvardhar (15) Region Phone nvarchar (24) Column Name Conden. mvardhar (24 Fax RegionID HomePage ntext RegionDesaription nchar (50) EmployeeTerritories Column Name Condensed EmployeeID B TerritoryID nvarchar (20 Employees Column Name Condensed 8 EmployeeID mvardhar (20) astName nvarchar (10 FirstName Tite mvar char (300 TiteOffiCourtesy nvardhar(25) BirthDate date time HireDate datetime Address nvarchar (60 nvarchar (150 City Region nvarchar(15) PostalCod nvarchar (10 mvardhar (150 HomePhone mvardhar (24) marchar (4) Extension Photo Image Notes ntex ReportsTo PhotoPath nvarchar(255) Orders Column Name Condensed 8 Order nchar(5) Customer ID EmployeeID OrderDate datetime RequiredDate date time Shipped ate datetime ShipVia Freight money ShipName nvardhar (40) ShipAddress nvarchar (60 mvardhar (150 ShipCity ShipRegion nvardhar (15) ShipPostalCode marchar (10) ShipCountry nvarchar (150 Shippers Column Name Condensed Shipper ID Company Name nvarchar (40) Phone nvarchar(24) Customers Column Name Condensed CustomerID nchar(5) char (40 Contact Name nvarchar(30) ContactTitie char (30 varchar (60) Address archar (15) nvarchar (15 Region PostalCode nvarchar(10) char (15 Country varchar (24) rchar(24) Custome rCustomerDemo Column Name Condensed 8 CustomerID nchar(5) Cust nchar(100 tomer raphics Column Name Conden CustomerTypeID nchar( tomerbesc ntext