Zestaw 3

2.A
sposób 1:

use Northwind
SELECT *, ShippedDate from [Order Details] od
join Orders o on o.OrderID = od.OrderID

sposób 2:

use Northwind
SELECT *, (SELECT ShippedDate from Orders where
	OrderID = [Order Details].OrderID) from [Order Details]

2.B

use Northwind
SELECT OD.* from [Order Details]  od join Orders o
on o.OrderID = od.OrderID where YEAR(OrderDate)=1997


2.C

use Northwind
SELECT od.*, CompanyName from Orders o
join Customers c on c.CustomerID = o.CustomerID
join [Order Details] od ON o.OrderID = od.OrderID