USE Northwind
GO

SELECT companyname
FROM customers
WHERE customerid IN
	(SELECT customerid
	 FROM orders
	 WHERE orderdate >'1/1/95')
go

SELECT distinct companyname
FROM customers c
	JOIN orders o ON  o.customerid = c.customerid
 WHERE orderdate >'1/1/95'
GO