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
10 points!
melisa1 [442]

Advantages;            

Firstly, the internet can let a person to communicate with people in virtually any parts of the world through the internet or e-mail, without having to leave his room. E-mail allowed peoples to communicate with minimum of times. It is now possibles to send a message to any parts of the world through a simple e-mail address and the message is delivered in matter of seconds. Every companies is using e-mail in business. The convenience of e-mail has allowed businesses to expand and communicates with their vendors and customers located all over the world in records times. Personal communication has also become more easier thanks to e-mail. Chat rooms, video conferencing are some of the latest additions in this technology and these have allowed peoples to chat in real time. Besides, there are a lot of messengers services in offering. With the help of such services, it has become very easy to establish a kind of global friendship where you can share your thoughts and explore other cultures. The internet also allows people within an organization to easily communicate and share informations.

Second, information is probably the biggest advantages that internet offers. Internet is a virtual treasures trove of information. Any kinds of information on any topic under the sun is available on the internet. The search engines like Google, Yahoo are at your service through the internet. There is a huge amount of information available on the internet for just about every subjects known to man, ranging from government law and services, trade fairs and conferences, market information, new ideas and technical support, the lists is simply endless. We can uses these search engines, websites dedicated to different subjects and large amount of articles and papers are available for perusal in a matter of a few seconds.

Forums on a number of sites allow peoples to discuss and share their thoughts and informations with others located at different places all over the world. Whether this information is the latest news happenings in the world or information about your favourite celebrity, everything is available at your finger tips. A huge cache of data is available on the internet on every single subjects. With this storehouse of information people can not only increases their knowledge bank but can do so without wasting their time through traditional means such as visiting libraries and conducting exhaustive research. With internet, students can save their times to search for information and using their time to do other works.

This is particularly relevant for students who can use this wealth of information for their school projects and also learn new things about the subjects they are interested in. In fact this internet is for many schools and universities that are now able to assigns projects and work to the students and follows their progress which can be easily posted on the school or university internal websites. Online education has grown at a very fast pace since internet allow the development and uses of innovative tools for imparting education. University students and lecturers can communicate through internet. Besides, some universities are also offerings far distances courses to make study become more inefficient and convenience. Internet become a gateway for those who wants to learn but cannot afford the living fees at foreign countries.

Thirdly, entertainments is another popular reasons why many people prefer to surf the internet. In fact, the internet has becomes quite successful in trapping the multifaceted entertainment industry. Downloading games or just surfing the celebrity websites are some of the uses people have discovered. Even celebrities are using the internet effectively for promotional campaigns. Besides that, there are numerous games that can be downloaded for free. The industry of online gaming has tasted dramatic and phenomenal attentions by game lovers. The internet has also revolutionized the entertainments industry. People nowadays no need to go to a cinema hall to watch your favourite movie. Instead of watching movies at cinema now have companies offering their services where you just can downloads or order your favourite movie and watch it with a fast internet connection. Besides that, you also can download other important software or your favourite music in a matter of few minutes. There are a number of shareware programs that allow you to share and download your favourite music and videos. The internet also allows people from different cultures and background to connect with each other. Internet gaming is a huge business and allow enthusiastic gamers to compete against each other in games even when they are located far apart. Likewise dating has also allowed people to find their prospective soul mates.

4 0
2 years ago
in the world of computing accessibilty most often refers to: a how quickly software opens , b password protection, c assistance
Wittaler [7]
C. assistance for the disabled
8 0
3 years ago
Very few games have any sort of narrative, not even a simple one that involves setting the mood through color, sound, environmen
Vladimir79 [104]

Answer:

B. False

Explanation:

Numerous amount of games have narrative, there is an entire genres built around narratives. Any RPG game has a narrative and even bog standard FPS games have some sort of backstory and effects setting a mood.

6 0
2 years ago
When you ask the database more complex questions using comparison operators, you are conducting a _____. sort questionnaire quer
Mice21 [21]
The correct answer is known as a "query".

When you ask a lot of complex questions , which uses comparison operators, that is called a query. A query refers to the <span>exact request for </span>data retrieval<span> with the use of database and information systems. </span>
8 0
3 years ago
Ill give brainliest if possible
AlekseyPX
I can’t see that zoom it in
8 0
3 years ago
Read 2 more answers
Other questions:
  • Can a Web developer guarantee that data presented is valid? Why or why not?
    9·1 answer
  • According to which virtue do you need to secure information by limiting computer access to authorized personnel only ?
    13·2 answers
  • What is the purpose of the print area feature​
    11·1 answer
  • Which grapgic element loads faster when used with text or audio
    7·1 answer
  • Which of these is NOT one of the main parts of an email?
    14·2 answers
  • Suppose that the domestic production of computer games creates enjoyment for those who play the games. Domestic production of co
    14·1 answer
  • Global address list characteristics
    11·1 answer
  • I can't find my grandson someone help
    14·2 answers
  • Which cpu type would most likely be found in a smartphone?.
    10·1 answer
  • 5 differences between a regular mouse and a gaming mouse​
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!