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
How can we style the images and layouts of our pages?
professor190 [17]

Answer

Using CSS and Html:)

Explanation:

4 0
2 years ago
"You are setting up a new subnetwork on an existing network. Management has asked that you use existing cabling that the company
NemiM [27]

Answer:

T10BASE-T networks require a minimum of Category 3 cable and connection hardware for proper operation.

Explanation:

The characteristics of this cable:

1. Complies with EIA / TIA - 568-B ISO / IEC 11801 Class C

2. 0.51 mm (24 AWG) solid copper conductor

3. PE (Polyethylene) insulation,

4. PVC outer cover,

5. no flame propagator and

6. self-extinguishing.

7. Twisted pair

8. SUITABLE FOR VOICE AND DATA INSTALLATIONS FROM 10Mbps to 16Mbps.

<u>It is suggested to buy the complete coil to change the wiring gradually. </u>

7 0
3 years ago
Why would a designer choose to use an isometric sketch rather than a perspective sketch to share their idea with a design team m
alexdok [17]

Designers use both isometric and perspective sketches to maintain an object’s visual proportions. Isometric sketches are 3D objects drawn with lines that have no vanishing points while perspective sketches are 3D objects drawn with one or more vanishing points.

Designers choose to use an isometric sketch because it is more accurate than perspective drawings and makes the design look more professional. Isometric sketches are much easier to handle because the length of each measure is same as the plan. This is especially for designers drawing pictures by hand. It is time saving and you do not need to calculate the angle of every edge.

8 0
3 years ago
100 POINTS. DO NOT SPAM. OR I WILL REPORT.
Dafna1 [17]

Answer:

Explanation:

In digital image processing, degradation is a process of introducing defects to the image. Understanding the degradation function will allow restoration of the original image.

There are many different causes for image degradation such as motion blur, digital noise and lens off-focus. In cases like motion blur, it is possible to come up with an very good estimate of the actual blurring function and "undo" the blur to restore the original image. For digital noise, a statistical model can be set up to compensate for the degradation it caused.  Similarly  lens focus can be compensate by an optical model if the mis-focus is known.

The above are three degradations that I could find. A lot more information can be found about restoration functions. If you search for image degradation online, you will find a discussion on Quora and an interesting introduction from Rice University. Good luck!

4 0
3 years ago
Read 2 more answers
Typically, a programmer develops a programâs logic, writes the code, and ____ the program, receiving a list of syntax errors.
miv72 [106K]
"debugs" is the answer
4 0
3 years ago
Other questions:
  • Once you select select a crop boundary, you can no
    15·1 answer
  • Who initially developed what is now known as the internet?
    5·1 answer
  • Computers are designed with what type of memory?
    13·1 answer
  • Which shortcut key combination will move the cursor to the beginning of the line?
    13·1 answer
  • I nees the meaning of these words even just one of them would help out ( pixel megapixel colour depth bit and byte)
    15·2 answers
  • A program that doesn’t work properly needs to be debugged. true or false
    8·1 answer
  • Software that requires excessive disk space or memory.
    15·1 answer
  • when demonstrating 2022 altima’s parking assistance, what steering feature should you mention when pointing out how easy the veh
    10·1 answer
  • Write A Code In Python
    8·2 answers
  • Edit the following statement so it uses the constant named YEAR:
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!