1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
OLga [1]
3 years ago
10

Your company is developing a new marketing campaign and wants to know which customers have never placed an order. You will need

to join the Sales.Customers and Sales.Orders tables. You will need to look for customers where there is no corresponding matched row in the orders table. The best join to use for this task is the left join. From the Customers table retrieve the customer id, company name, contact name, country, and phone. Provide the full SQL statement for the answer
Computers and Technology
1 answer:
Mrrafil [7]3 years ago
4 0

Answer:

See explaination

Explanation:

Using the left outer join:

select custid,companyname,contactname,country,phone from sales.customers left outer join sales.orders on sales.customers=sales.order;

You might be interested in
You are leading a project that will collect vast amounts of data, which will need processing. In your research, you learn about
Helga [31]

Answer:

Grid Computing

Explanation:

Grid computing is a processor architecture that combines computer resources from various domains to reach a main objective. In grid computing, the computers on the network can work on a task together, thus functioning as a supercomputer.

Cheers

5 0
2 years ago
Read 2 more answers
Write a short note on "History of WWW" (word limit = 100-150 words)​
mihalych1998 [28]

Explanation:

it looks like there aren't many great matches for your search

Tip Try using words that might appear on the page that you’re looking for. For example, 'cake recipes' instead of 'how to make a cake'.

I hope you help

4 0
2 years ago
Read 2 more answers
Plz help me I need help​
Digiron [165]

Answer:

ok i will help you

you can asked

8 0
2 years ago
If a team member comes from a(n)________(fill in the blank) culture, he or she will be more likely to expect the team members to
OleMash [197]

collectivistic culture

6 0
2 years ago
An advantage of assigning primary responsibility for user support to the IT department is that all computer activities are combi
Marat540 [252]

Answer:

true

Explanation:

Because assigning primary responsibility for user support to the IT department is that all computer activities are combined and users know who to contact about various computer problems.

8 0
2 years ago
Other questions:
  • A plan to budget time for studying and activities is referred to as
    15·1 answer
  • What should you do if ads keep popping up on your computer when using Google Chrome?
    14·1 answer
  • How can volunteering to help plan a fundraiser for your team or club be a way to develop your strengths?
    10·2 answers
  • What is the purpose of copyfitting?
    12·1 answer
  • If E=mc2 then what does F equal?
    10·1 answer
  • Write a function that will sum all of the numbers in a list, ignoring the non-numbers. The function should takes one parameter:
    8·1 answer
  • I'm getting pretty desperate plz help me, I'll give brainiest, and ill make a free question worth 100 points this is for coding
    10·1 answer
  • A web application with an SQL server database is found to be compromised by an attacker. On examination, the email IDs of the da
    5·1 answer
  • Resource _____ let you view, manage, and automate tasks on multiple aws resources at a time.
    9·1 answer
  • I want to build a video player on the html5 canvas here is my code
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!