help out asap please

1 Count the number of products by Category Name ? Count the number of products by Supplier Name 3 Display Order count by Product Name Display Order count by Category Name Display Order Amount by category name Display Order Amount by product name Display Order Amount by Employee Name Display Order Amount by Customer organization name Display Employee Names and their manager names Display Order count by shipper organization name Display Order count by category name Display Order count by product name Display Order count by Employee Name Display territories by region (use description fields instead of IDs for the display) 14 Turtle Leng Weeken X This service is set to discorx alanda/mod/assign/view.php?id=129 Training 1 Fetch all the customers that are not from region 'BC' or 'SP' 2 Show all customer contact names and titles for the business owners who are from Germany or France 3 Fetch customers from Germany, Mexico and Sweden 4 Display customers that are from Switzerland but not from city Bern 5 Display total amount by Order ID 6 Count the number of products by Category ID 7 Count the number of products by Category ID and Discontinued status 8 Count the number of products by Supplier ID and Category ID 9 Count the number of products that need to be re-ordered 10 Count the number of products by category ID that are sold in bottles 11 Display categories with product count of 5 or more 12 Display employeed ID and order count by employee 13 Display employee and order count for employees with 50 or more orders 14 Display Order count by ProductiD 15 Display Item count by Order ID 16 Display territory count by Region ID 17 Display suppliers from Germany, UK and Japan but exclude suppliers from London city 18 Display supplier count by Country 19 Count orders by month 20 count orders by year 21 count orders by year and month Get the first Order date QL Training 17 Display suppliers from Germany, UK ana japan but exciuae suppliers from London City 18 Display supplier count by Country 19 Count orders by month 20 count orders by year 21 count orders by year and month 22 Get the first Order date 23 Get the latest Order Date 24 Get the first and last order dates by years Submission status No attempt Submission status Grading status Not graded Last modified Submission comments Comments (0) # Graph Tables E dbo.Categories + dbo.CustomerCustomerDem + 2 dbo.CustomerDemographics + dbo.Customers + 2 dbo.Employees dbo.Employee Territories # #dbo.Order Details # dbo.Orders * dbo.OrdersDemo + dbo.Products # dbo.Region # dbo.Shippers dbo.Suppliers + dbo.Territories # Views External Resources Ready # ---Count the nu ---Display Order select count(*) from[dbo].[Order System Databases Database Snapshots Northwind Database Diagrams Tables System Tables File Tables External Tables # Graph Tables B dbo.Categories 3 Columns - CategoryID (PK, int, not CategoryName (nvarcha Description (ntext, null) Picture (image, null) Keys Constraints Triggers Indexes # Statistics odbo.CustomerCustomer Dem om dbo.Customer Demographics o dbo.Customers mdbo.Employees mdbo.Employee Territories 100 % 4. Connected. (1/1) O Ready ---Count the numb B ---Display Order select count(*)[d from[dbo].[Orders] Northwind Database Diagrams B Tables # System Tables # FileTables External Tables Graph Tables #dbo.Categories #dbo.CustomerCustomer Den odbo.Customer Demographics dbo.Customers Columns - CustomerID (PK, nchar(5 Company Name (nvarch Contact Name (nvarchar ContactTitle (nvarchar(30 Address (nvarchar(60), City (nvarchar(15), null) Region (nvarchar(15), nu Postal Code (nvarchar(10 Country (nvarchar(15), n Phone (nvarchar(24), nul Fax (nvarchar(24), null) Keys 100 % 4. Connected. (1/1) O Ready SETELL --Count the numbe E ---Display Order co select count(*)[dt from[dbo].[Orders ] = dbo.Categories # 5 dbo.Customer Customer Der dbo.Customer Demographics # dbo.Customers dbo.Employees B Columns - Employeeld (PK, int, not LastName (nvarchar(20), FirstName (nvarchar(10) Title (nvarchar(30), null) TitleOfCourtesy (nvarcha BirthDate (datetime, null HireDate (datetime, null Address (nvarchar(60), City (nvarchar(15), null) Region (nvarchar(15), nu PostalCode (nvarchar(10 Country (nvarchar(15), n B HomePhone (nvarchar(2 Extension (nvarchar(4), Photo (image, null) Notes (ntext, null) -- Reports To (FK, int, null) PhotoPath (nvarchar(25: Keys Constraints Triggers 100 % - Connected. (1/1) O Ready Object Explorer sect *** O th ---Count the num select * ---Count the numb ---Display Order select count(*)[ from [dbo].[Orders] # dbo.Categories # dbo.CustomerCustomer Der #dbo.Customer Demographics # dbo.Customers # dbo.Employees # dbo.Employee Territories Em dbo.Order Details R Columns - OrderID (PK, FK, int, not - ProductID (PK, FK, int, n UnitPrice (money, not nu Quantity (smallint, not n Discount (real, not null) Keys Constraints Triggers Indexes Statistics mdbo.Orders E dbo.OrdersDemo mdbo.Products mdbo.Region odbo.Shippers mdbo.Suppliers mdbo.Territories Views External Resources 100 % 4. Connected. (1/1) O Ready ---Count th ---Display select cour from[dbo].[C # dbo.CustomerCustomer Den + = dbo.Customer Demographics dbo.Customers # dbo.Employees dbo.Employee Territories + dbo.Order Details 2 dbo.Orders Columns * OrderID (PK, int, not nul * CustomerID (FK, nchar(5 en Employeeld (FK, int, nul Order Date (datetime, nu RequiredDate (datetime ShippedDate (datetime, 8 ShipVia (FK, int, null) Freight (money, null) ShipName (nvarchar(40) ShipAddress (nvarchar(6 ShipCity (nvarchar(15), Ship Region (nvarchar(1) ShipPostalCode (nvarch Ship Country (nvarchar(1 Keys Constraints Triggers Indexes 100 % - 4. Connected. (1/1) O Ready --Count the number ---Display Order cou select count(*)[dbo from[dbo].[Orders] odbo.Categories # dbo.CustomerCustomerDem 2 dbo.Customer Demographics # dbo.Customers dbo. Employees dbo.Employee Territories # dbo.Order Details dbo.Orders # dbo.OrdersDemo B dbo.Products Columns - ProductID (PK, int, not n ProductName (nvarchan - SupplierID (FK, int, null) CategoryID (FK, int, null) QuantityPerUnit (nvarch UnitPrice (money, null) UnitsinStock (smallint, n Units OnOrder (smallint, ReorderLevel (smallint, Discontinued (bit, not n Keys Constraints Triggers Indexes Statistics mdbo.Region 100 % 4. Connected. (1/1) O Ready nnect T U V select * ---Count the number of prodi ---Display Order count by Pr select count(*)[dbo].[Order from[dbo].[Orders] dbo.Categories dbo.Customer Customer Der # dbo.Customer Demographics Edbo.Customers dbo. Employees dbo. Employee Territories dbo.Order Details # dbo.Orders dbo.OrdersDemo dbo.Products om dbo.Region Columns -RegionID (PK, int, not nu RegionDescription (ncha Keys Constraints Triggers Indexes Statistics mdbo Shippers mdbo.Suppliers mdbo.Territories Views External Resources Synonyms Programmability Service Broker 100 % - * Connected. (1/1) Ready ---Count the number of pr select ---Count the number of pro ---Display Order count by F select count(*)[dbo].[Orde from[dbo].[Orders] nnect T T Yth = dbo.Categories # dbo.CustomerCustomer Der # = dbo.Customer Demographics dbo.Customers # dbo.Employees # dbo.Employee Territories # dbo.Order Details B dbo.Orders # dbo.OrdersDemo mdbo.Products mdbo. Region Emdbo.Shippers Columns - ShipperID (PK, int, not n CompanyName (nvarch Phone (nvarchar(24), nu Keys Constraints Triggers Indexes Statistics dbo.Suppliers mdbo.Territories Views External Resources Synonyms Programmability 100 % - 4. Connected. (1/1) Ready ---Display Order count by select count(*)[dbo].[Ord from [dbo].[Orders] dbo.Employees odbo.Employee Territories # dbo.Order Details dbo.Orders # dbo.OrdersDemo dbo.Products dbo.Region dbo.Shippers B dbo.Suppliers Columns - SupplierID (PK, int, not Company Name (nvarch Contact Name (nvarchar Contact Title (nvarchar(31 Address (nvarchar(60), City (nvarchar(15), null) Region (nvarchar(15), nu Postal Code (nvarchar(10 Country (nvarchar(15), n Phone (nvarchar(24), nul Fax (nvarchar(24), null) HomePage (ntext, null) Keys 100 % - * Connected. (1/1) Ready