Sql server express edition and adventureworks

Reference no: EM13733661

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 %';

Reference no: EM13733661

Questions Cloud

Why principles-based standards require conceptual framework : What aspects of the requirements were used by US companies to defer recognition of a liability - Explain why principles-based standards require a conceptual framework.

What is a pro forma invoice and what is a purchase orders : What's a Pro Forma invoice? How are these used in international trade? What does one look like? Is there a standard form

Actuarial table indicates-anticipated years in retirement : You want to retire in 35 years. The Actuarial table indicates that your anticipated years in retirement will be 20 years. If you anticipate the return on your investments will be 5% and you wish to get $100,000 per year in retirement, how much money ..

Environment for opportunities and threats to a company : Examining the external environment for opportunities and threats to a company, brand, and product is an essential step in the development of a marketing strategy

Sql server express edition and adventureworks : 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..

Describe the leadership style of the ceo : Analyze the CEO's leadership style and philosophy, and how the CEO's leadership style aligns with the culture.

Dependence that exist between the type of ticket and flight : A bloom berg business week subscriber study asked In the past 12 months when traveling for business what type of airline ticket did you purchase most often? a second question asked if the type of airline ticket purchased most often was for domestic o..

The jukebox will be capable of playing virtually any : For the Course Project, you are going to build your own personal jukebox. The jukebox will be capable of playing virtually any .WAV file in any order that you please. You will be supplied with a number of blues tunes and popular songs from the early ..

Ordering electronic component from three different supplier : Benson manufacturing company is considering ordering electronic components from three different suppliers. The supplier may differ in terms of quality in that the percentage of defective components may differ among the suppliers. To evaluate the prop..

User Account

All Pages