All questions are based on the Northwind database.

Q1) Write a query to list the ProductName, CategoryName and Quantity of product ordered if the Quantity of product ordered was the largest quantity ordered in that products category. (n some cases it may be possible that multiple products within a category may have the same values of quantity that are the maximum ordered).

Q2) Write a query to list the company names of customers who only use 1 shipper to ship all their orders.

Products Column Name ProductID Product Name Supplier ID CategoryID QuantityPerUnit nvarchar(20) Suppliers Condensed... int Country Phone Fax UnitPrice money UnitsInStock smallint UnitsOnOrder smallint ReorderLevel Discontinued smallint bit HomePage nvarchar(40) int int Column Name Supplier ID Company Name nvarchar(40) ContactName nvarchar(30) ContactTitle nvarchar(30) Address nvarchar(60) nvarchar(15) City Region nvarchar(15) Postal Code nvarchar(10) nvarchar(15) nvarchar(24) nvarchar(24) ntext Condensed... int Order Details Column... Conde... OrderID int 8 ProductID int UnitPrice money Quantity smallint Discount real Categories Column Name Category D CategoryName Description Picture Territories Condensed... int nvarchar(15) ntext Image Column Name TerritoryD TerritoryDescription RegionID Region Condensed... nvarchar(20) nchar(50) int Column Name Conden... int RegionID RegionDescription nchar(50) Employee Territories Column Name Condensed T... EmployeeID int TerritoryID Employees Column Name EmployeeID LastName FirstName Title nvarchar(20) BirthDate HireDate Address City Region PostalCode Country HomePhone Extension Photo Notes Reports To PhotoPath Condensed... int nvarchar(30) TitleOfCourtesy nvarchar(25) datetime datetime nvarchar(20) nvarchar(10) nvarchar(60) nvarchar(15) nvarchar(15) nvarchar(10) nvarchar(15) nvarchar(24) nvarchar(4) image ntext int nvarchar(255) 000 Orders Condensed... int nchar(5) int datetime datetime datetime Column Name OrderID Customer ID EmployeeID Order Date RequiredDate ShippedDate ShipVia Freight ShipName ShipAddress ShipCity ShipRegion ShipPostal Code nvarchar(10) ShipCountry nvarchar(15) int money nvarchar(40) nvarchar(60) nvarchar(15) nvarchar(15) Shippers Column Name Condensed... ShipperID int Company Name nvarchar(40) Phone nvarchar(24) bo- Customers Column Name Condensed... Customer 10 nchar(5) Company Name nvarchar(40) ContactName nvarchar(30) nvarchar(30) nvarchar(60) nvarchar(15) nvarchar(15) ContactTitle Address City Region PostalCode Country Phone Fax nvarchar(10) nvarchar(15) nvarchar(24) nvarchar(24) CustomerCustomerDemo Column Name Condensed T... CustomerID nchar(5) Customer... nchar(10) CustomerDemographics Column Name Conden... CustomerTypeID nchar(10) CustomerDesc ntext