SQL

These problems analyze data from the Northwind database. Read the comments and create a VIEW for each data request

-- Data Request: 0303

-- Request: I want a list of products, their standard price and their categories.

-- Order the results by Category Name and then Product Name, in alphabetical order.

/*

-- Columns

c.CategoryName

p.ProductName

p.UnitPrice

-- Tables

Northwind.dbo.Products

Northwind.dbo.Categories

-- Connections

???

*/

-- Data Request: 0323

-- Request: I want a list of products, their standard price and their categories.

-- Order the results by Category Name and then Product Name, in alphabetical order but only for the seafood category

/*

-- Columns

c.CategoryName

p.ProductName

p.UnitPrice

-- Tables

Northwind.dbo.Products

Northwind.dbo.Categories

-- Connections

???

*/

-- Data Request: 0317

-- Request: I want a list of how many orders our customers have placed each year

/*

-- Columns

c.CompanyName

od.OrderID

o.OrderDate

-- Tables

Northwind.dbo.Customers

Northwind.dbo.Orders

-- Connections

???

-- Functions

Year()

Count()

*/

-- Data Request: 0318

-- Request: I want a list of total order dollars our customers have placed each year

/*

-- Columns

c.CompanyName

od.OrderID

od.Quantity

od.UnitPrice

o.OrderDate

-- Tables

Northwind.dbo.Customers

Northwind.dbo.Orders

Northwind.dbo.[Order Details]

-- Connections

???

-- Functions

Year()

Count()

Sum()

Format()

*/