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 early Oklahoma, __________ tribes were most nomadic. A. hunting B. farming C. semi-sedentary D. agricultural Please select th
denpristay [2]

Answer:

A

Explanation:

They needed to follow the food/buffalo

5 0
3 years ago
Write a C program that does the following: Creates a 100-element array, either statically or dynamically Fills the array with ra
ANEK [815]

Answer:

Following are the code to this question:

#include <iostream>//header file

using namespace std;

int main()//main method

{

   int axb[100];//defining 1-array of 100 elements

   int odd_axb[100], even_axb[100];//defining two array that holds 100-elements

   int i,size=0,size1=0;

   for(i = 0; i < 100; i++)//defining for loop to assign value in array

   {

       axb[i] = rand() % 100 + 1;//using rand method to assign value with random numbers between 1 and 100

   }

   for(i = 0; i < 100; i++)//defining for loop that seprates array value in odd and even array

   {

       if(axb[i] % 2 == 0)//checking even condition  

       {

           even_axb[size++] = axb[i];//holding even number

       }

       else//else block

       {

           odd_axb[size1++] = axb[i];//holding Odd number

       }

   }

   //printing values

   cout << "Odd array: ";//print message  

   for(i = 0; i <size1; i++)//use for loop for print odd numbers

   {

   cout << odd_axb[i]<<" ";//printing values

   }

   

   cout <<"\n\n"<< "Even array: ";//print message

   for(i = 0; i <size; i++)//use for loop for print even_axb numbers

   {

       cout << even_axb[i] << " ";//printing values

   }

   return 0;

}

Output:

Odd array: 87 87 93 63 91 27 41 27 73 37 69 83 31 63 3 23 59 57 43 85 99 25 71 27 81 57 63 71 97 85 37 47 25 83 15 35 65 51 9 77 79 89 85 55 33 61 77 69 13 27 87 95  

Even array: 84 78 16 94 36 50 22 28 60 64 12 68 30 24 68 36 30 70 68 94 12 30 74 22 20 38 16 14 92 74 82 6 26 28 6 30 14 58 96 46 68 44 88 4 52 100 40 40

Explanation:

In the above-program, three arrays "axb, odd_axb, and even_axb" is defined, that holds 100 elements in each, in the next step, three integer variable "i, size, and size1" is defined, in which variable "i" used in the for a loop.

In the first for loop, a rand method is defined that holds 100 random numbers in the array, and in the next, for-loop a condition statement is used that separates even, odd number and store its respective array, and in the last for loop, it prints its store values  

5 0
3 years ago
Why might you need to convert a file to another file type?
Elis [28]
c i belive that is the right answer

5 0
3 years ago
Read 2 more answers
When selecting Internet research sources, you should verify that the source is _____ and _____.
Naddik [55]
Current and credible
7 0
3 years ago
Biyu is making arrangements to use a third-party service provider for security services. She wants to document a requirement for
Sholpan [36]

Answer:

The correct option of the following question is A.) Service level agreement(SLA).

Explanation:

The contract between its internal or the external customer and service providers that document what the services provider will furnish, defines service standard the provider is an obligated to meet is known as SLA(Service Level Agreement).

There are three types of SLA.

  • Customer-based SLA.
  • Service-based SLA.
  • Hierarchical and the multi-level SLA.
3 0
3 years ago
Other questions:
  • When parking ur vehicle facing downhill with a curb, you should point ur front wheels?
    7·2 answers
  • What should you do if your computer keeps shutting down while working?
    9·2 answers
  • Help me please (program c++)
    11·1 answer
  • The first widely adopted windows product, ____, featured a standardized look and feel, similar to the one made popular by apple'
    11·1 answer
  • List at least three benefits of automated testing?
    13·1 answer
  • A user on a home network needs to boost the signal of the wireless router. What should the user purchase to accomplish this?
    14·1 answer
  • Distributed computing is a term that describes the work that autonomous computers can do to achieve a common goal, especially in
    10·1 answer
  • In working on the conceptual design of the new database, Ken determines that the "office" field in one of the tables must includ
    8·1 answer
  • Viết chương trình hoàn chỉnh các yêu cầu sau:
    8·1 answer
  • What keyword can we use within a form to pass it as an argument to a JavaScript snippet? A. form B. onSubmit C. send D. this
    15·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!