Import the assignment data code and use the following logical schema to answer questions below. Note that you won't get any credits if you use codes that haven't learned in Topic 8 - Filtering Grouping Data or before. In this assignment, you can create VIEW table for any questions. Make sure to write appropriate comments to show the questions you want to answer (-1 point if you don't): Products Orders Column Name Condensed Type Nulla.. Column Name Condensed Type Nullable Product D Employees in? Customers No Order ID No Column Name ProductName Condensed Type Nullable nvarcher(40) No Column Name Condensed ... CustomerID nchar(S) Yes Nul... EmployeeID No peter(5) Suppher ID Yes EmployeeID inc LastName nvarchar(20) No Companyflame neverchar(40) NO CategoryID Yes OrderDate time FirstName nvarchar(10 No ContactName Quantity PerUnit nvarcher(20 Yes RequiredDate datetime Yes Tide nvarchar(30) Contact Title UnitPrice money Yes Shipped Dace datetime Yes Title OfCourtesy nvarchar ( 25) Yes Address UnitsinStock smalline Ship Via int Yes Birth Date datetime Yes CAY varcher UnitsOnOrder smalling Yes Freight toney Yes HireDate davetime Region OV BECBRY 15) ReorderLevel smallint Yes ShipName nvarchar(40 Yes Address nvarchar(60) Yes PostalCode nvarchar(10) Y Discontin bi Ship Address nvarchar( 60) Yes City nvarchar(15) Yes Country nvarchar(15) Yes ShipCity nvarchar(15) Yes Region nvarcher (15 ) Yes Phone nvarcher(24) Yes ShipRegion nvarchar(15) PostalCode nvarchar ( 10) Yes nvarchar(24) Yea Ship PostalCode nvarchar(10) Country nvarchar( 15 Yes Ship Country nvarcher(15) Home Phone nvarchar ( 24 ) Yes Excension nvarchar( 4 ) Yes Suppliers Photo image Yes Column Name Condensed Type Nullable Noses Yes Supplier ID ing CustomerCustomerDemo No Reports To int Yes CompanyName nvarchar(40) Column Name Nulltable No Photo Part nvarchar(255 Yes Customer ID nchar(5) No ContactName nvarchar(30) Yes Order Details Customer Type... nchar( ID) No Contact Title nvarchar(30) Yes Column Name Condensed Type Nullable Address nvarchar(60) Yes OrderID he No varchar(15) Yes ProductID Region nvarchar(15) Yes UnixPrice honey No EmployeeTerritories PostalCode nvarchar(10) Yes Quantity mallint No Column Name Condensed ... N... CustomerDemographics nvarcher(15) 8 EmployeeID No Condens.. NoL.. Country Yes Column Name Discount Yes TerritoryID nvarchar(20) No nvarchar(24) Customer TypeID achar (10) No Phone somer Desc Ye nvarchar(24) Yes HomePage ntext Categories Territories Column Name Condensed Type Nullable Column Name Condensed ... Now Shippers 9 CategoryID int No TerritoryID nvarchar(20) No Column Name Nal CategoryName no char( 15) NO TerritoryDescript... ochar(50) ShipperID No Region Description Yes RegionID Company Name nvarchur (40) No Column Name Condens... Null... Picture image You RegionID No RegionDescription nchar(50) NoTerritory10 CategoryName nvarchar(15) No Column Name Region TerritoryDescript.. nchar(50) Condensed ... Null... Description Yes ShipperID int No Column Name Picture RegionID CompanyName nvarchar(40) No 8 RegionED nvarchar(24) Yes Region Description 1. View Problem: Create View to view all order info 2. Condition Testing Problem: Show first name, last name of employee, and indicate whether employee lives in California and Oregon. 3. Create View to display orders which has more than 5 product quantity sold (1 point) 4. Create View to display info of products which has highest average quantity sold (1 point) 5. Create View to display total numbers of customers purchased orders for each day (1 point) 6. Show info of products, and indicate whether the product is discount or not (1 point) 7. List customer info and indicate whether the customer purchase any order (1 point) 8. Show employee's first and last name, and indicate whether the employee lives in New York or Boston (1 point). 9. Name your own query question and answer it (1 point) 10. Name your own query question and answer it (1 point)