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