SQL Pierrot Queries

Pierrot Queries

SELECT CompanyName,ContactName
FROM Customers
WHERE CustomerID = 75010
go

SELECT FirstName, LastName, Extension
FROM Employees
WHERE EmployeeID = 1
go

SELECT ProductName, UnitPrice
FROM Products
WHERE ProductID = 1
go

Select CompanyName, Phone 
FROM Shippers
WHERE ShipperID = 1
go

SELECT e.LastName, p.ProductName, sum(d.Quantity * d.UnitPrice) 
FROM Employees e, Orders o, [Order Details] d, Products p
WHERE e.EmployeeID = o.EmployeeID
and o.OrderID = d.OrderID
and d.ProductID = p.ProductID 
GROUP BY e.LastName, p.ProductName
go

SELECT e.LastName, p.ProductName, avg(d.Quantity * d.UnitPrice)
FROM Employees e, Orders o, [Order Details] d, Products p
WHERE e.EmployeeID = o.EmployeeID
and o.OrderID = d.OrderID
and d.ProductID = p.ProductID
GROUP BY e.LastName, p.ProductName
go

SELECT p.ProductName, sum(d.Quantity * d.UnitPrice) 
FROM [Order Details] d, Products p
WHERE d.ProductID =  p.ProductID 
GROUP BY p.ProductName
go

SELECT e.LastName, e.FirstName, Count(o.OrderID)
FROM Employees e, Orders o
WHERE e.EmployeeID = o.EmployeeID
GROUP BY e.LastName, e.FirstName
go

Select p.ProductName, p.ProductId
FROM [Order Details] d, Products p
WHERE d.ProductID = p.ProductId
and d.UnitPrice > 10
go