Assignment 1 SQL Server Express Edition and AdventureWorksLT2012 answer to Unit 3 is not provided for Questions 4 and 10 which I need, and Question 9 code returns no results (assignment requires Join statements which I was able to use). Please advise. This is what I have:
use AdventureWorksLT2012
Select Customer.CustomerID, CompanyName
from SalesLT.Customer, SalesLT.Address, SalesLT.CustomerAddress
WHERE Customer. CustomerID= CustomerAddress. CustomerID
AND CustomerAddress.AddressId= Address. AddressId
AND Address.AddressLine1 Like '%United States %' OR Address.AddressLine2 Like '%United States %';