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
IN MICROSOFT EXCEL YOU CAN UES FOMULA TO DIVIDE OR MULTIPLY WHAT IS THE CORRECT FORMULA TO CALCULATE 4*6
nexus9112 [7]

You actually have the correct answer. An excel formula starts with = so your answer would be =4*6

8 0
3 years ago
Learning from and working collaboratively with individuals is being literate in which area
solniwko [45]
I think it should be civic literacy
7 0
3 years ago
Read 2 more answers
Which U.S. government agency first funded the development of the Internet?
Doss [256]

Answer: ARPANET

Explanation: The first workable prototype of the Internet came in the late 1960s with the creation of ARPANET, or the Advanced Research Projects Agency Network. Originally funded by the U.S. Department of Defense, ARPANET used packet switching to allow multiple computers to communicate on a single network.

7 0
3 years ago
Read 2 more answers
I WILL STAR YOU AND THANKS YOU!!!!!!!!!!!!!!!!
lord [1]
The answer seems to be polymerization.
 
8 0
3 years ago
Which is not a category of business or industry covered under OSHA standards? A. Construction B. General Industry C. Maritime D.
cestrela7 [59]
The answer from the given option is "D", "<span>OSHA covers all categories of business and industry".


OSHA stands for </span>Occupational Safety and Health Administration, which is an agency of the United States Department of Labor. The four categories of business and industry that are covered by the standards are general industry, maritime, construction and agriculture. So the the answer from the given options is D, because a, b and c are included in the categories.
5 0
3 years ago
Other questions:
  • The first character of the VIN designates which of the following? 
    15·2 answers
  • Which of them does not support decision making? Options DSS, GDSS, ESS All of above
    10·1 answer
  • Suppose that sum is an int variable. The statement sum += 7; is equivalent to the statement sum = sum + 7;
    7·1 answer
  • Mateo could not find the undo command or shortcut. He should _____.
    15·2 answers
  • In a singing competition, there are 34 more men than women
    5·2 answers
  • A college student needs a laptop that can be used while committing on the train and sitting in a lecture
    13·1 answer
  • If you want to insert a column into an existing table, what would you do?
    13·2 answers
  • What is the IEEE 802 standards name for a wireless network that is limited to one person's workspace?
    14·1 answer
  • Is a collection of information stored under a single nam​
    6·2 answers
  • Jason Chang is creating photos of his restaurant for a new website. Some of the photos of the staff have red eye, others are bad
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!