Answer Happy

NORTHWIND: Write a query to list category names and the value of
inventory from each category in stock (UnitPrice x UnitsInStock)
for all categories of products with more than $10,000 in
inventory.
Condensed... Employee Territories Column Name Condensed T... EmployeeID TerritoryID nvarchar(20) int int Order Details Column ... Conde... Order ID int ProductID int UnitPrice money Quantity smalint Discount nchar(s) bo Products Column Name Condensed... ProductID int ProductName nvarchar(40) Supplier ID int CategoryID int QuantityPerUnit nvarchar(20) UnitPrice money . UnitsInStock smallint inition UnitsOnOrder smallint ReorderLevel smallint Discontinued bit int real Orders Column Name OrderID Customer ID Employee Order Date RequiredDate ShippedDate Shipvia Freight ShipName ShipAddress Ship City ShipRegion ShipPostalCode ShipCountry datetime datetime datetime Int Customers Column Name Condensed... 8 Customer ID 7 nchar(5) Company Name nvarchar(40) ContactName nvarchar(30) Contact Title nvarchar(30) Address nvarchar(60) Oty nvarchar(15) Region nvarchar(15) PostalCode nvarchar(10) Country Darchulas nvarchar(15) Phone nvarchar(24) Fax nvarchar(24) Categories Column Name Condensed... CategoryID int CategoryName nvarchar(15) ntext money nvarchar(40) nvarchar(60) ) nvarchar(15) nvarchar(15) nvarchar(10) nvarchar(15) - DOC Description Picture image CustomerCustomerDemo Column Name Condensed T... 8 Customer ID nchar(5) Customer.. nchar(10) Suppliers Column Name Condensed... 7 SupplierID int CompanyName nvarchar(40) ContactName nvarchar(30) Contact Title nvarchar(30) nvarchar(60) City nvarchar(15) Region nvarchar(15) Postal Code nvarchar(10) Country nvarchar(15) Phone nvarchar (24) Fax nvarchar(24) HomePage ntext Territories Column Name Condensed... TerritoryID nvarchar(20) TerritoryDescription nchar(50) RegionID int Address Employees Column Name Condensed ... 3 Employee int LastName nvarchar(20) FirstName nvarchar(10) Title nvarchar(30) TitleOfCourtesy nvarchar(25) BirthDate datetime HireDate datetime Address nvarchar(60) City nvarchar(15) Region nvarchar(15) Postal Code nvarchar(10) Country nvarchar(15) Home Phone nvarchar(24) Extension nvarchar(4) Photo image Notes ntext Reports To int PhotoPath nvarchar(255) Shippers Column Name Condensed... 8 8 ShipperID int Company Name nvarchar(40) Phone nvarchar(24) Customer Demographics Column Name Conden... Customer TypeID nchar(10) Customer Desc ntext Region Column Name Conden... 8 RegionID int RegionDescription nchar(50)
Order Details Column Name Data Type Allow Nulls Orderin int Data T int nchar(5) int int 8 Product Unit Pride Quantit Discou Alow Nuls דרדראס datetime datetime datetime Allow Nulls Orders Column Name Order ID CustomerID Employeeld Order Date Required Date Shipped Date Ship Via megt Freight ShipName Ship Address Shipoty ShipRegion Ship Postal Code Ship Country money smalint rea int Employees Column Name Employee LastName FirstName Title TitleOfCourtesy BirthDate HireDate Address ✓ money Customers Column Name 8 Customer ID Company Name Contact Name Contact Tele NA Address Gty Region Postal Code Country Phone Fsx nvarcha (4 Shippers nvarchar(60) Data Type nchar(5) nvarchar(40) nvarchar(30) purther 2013 nvarcha (30) ini Darbas nvarchar(15) nvarchar(15) nvercha10) nvercha(15) nvarchar(24) nvarcha (24) Cmn Name Data Type Allow Nulls w nvarchar(6 watch nvarchar(1 nvarchar(1 nvarchar(1 nvarchar(1 Shippe? int Data Type int nvarchar(20) nvarchar(10) nvarchar(30) nvarchar(25) datetime datetime nvarchar(60) nvarchar(15) nvarchar(15) nvarchar(10) nvarchar(15) nvarchar(24) nvarchar(4) image ntext int City Compa, Name nvarchar(40) nvarchar(24) Phone ✓ Region Postal Code Country HomePhong Extension Photo Notes ReportsTo Allow Nulls PhotoPath nvarchar(255) Categories Column Name CategoryID Category Name Description Picture DataT int nvarchar(1 ntext image Employee Territories Column Name Data Type EmpbyD int Territo niercher (20)