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
garri49 [273]
4 years ago
6

The CUSTOMERS and SALES tables contain these columns:

Computers and Technology
1 answer:
ella [17]4 years ago
6 0

Answer:

Using join on both table against column CUST_ID will return customer ID, company and total sales

Explanation:

select

CUSTOMERS.CUST_ID,

CUSTOMERS.COMPANY,

SALES.TOTAL_SALES

from CUSTOMERS JOIN SALES

ON

CUSTOMERS.CUST_ID=SALES.CUST_ID

Above query selects required customer id and company table from customers table and total sales from sales table and apply join against customer id

JOIN in sql returns all the row where for a value in first table there is a matching value in second table.

You might be interested in
Polaroid had a unique competitive advantage for many years until it forgot to observe competitive intelligence. The firm went ba
Snowcat [4.5K]

Answer:

false

Explanation:

Based on the information provided within the question it can be said that the statement being made is false. This statement does not exemplify Porter's threat of new entrants, since this talks about the threat of new companies entering the same market with the same product in order to compete with the existing competitors in that market. In this scenario the new companies that eventually made Polaroid Bankrupt had an innovative new technology and which people starting using and left the entire Polaroid Market behind.

8 0
3 years ago
If your Word page is visually confusing after combining documents, one way to simplify the page is to select Hide Source Documen
FrozenT [24]
I’m not really sure but I’ll T
6 0
4 years ago
A company has recently learned of a person trying to obtain personal information of the employees illegally according to which a
wel
This is illegal. The person responsible for this could be sent to jail for a very long time. He should also be fired. 
7 0
3 years ago
Which of the following is a good precaution to take when making online purchases? (1 point)
Fantom [35]

Answer:

A.

Explanation:

A is the answer..

This is because you can use a private browser for safety precautions so no hackers would target you and steal your personal information. Also the other options make no sense at all. Option B states that you can use the same strong password for all online accounts and that's not good. It's not recommended because hackers or other people on the dark web can hack into your accounts and steal your data. Option C states that you must make sure http: and an open padlock displays on the address bar. This means that your connection is insecure and people can track you down. Option D is a good thing to do but option A is the best option overall. It's the right step to take when making online purchases <3

5 0
3 years ago
C++ automatically stores _____ in all uninitialized static member variables.
oksian1 [2.3K]

Answer:

The answer is "0".

Explanation:

The static variable is a member variable, which was configured at the start of implementation once only. It uses the static keyword to define any variable, It generates only one copy of the value throughout the program.  

  • In C++, when the class is static so, there is no need to create an object of the class.
  • When we declare the static variable it automatically assigns value "0" to a variable, that's why the answer is 0.
6 0
3 years ago
Other questions:
  • You put $500 in an interest bearing bank account that pays 2% per year but has a fee of $2 per month. Are you getting ahead?
    14·2 answers
  • Which of the follow represents a form of disruptive technology? Tend to open new markets and destroy old ones A new way of doing
    11·1 answer
  • How do you optimize a website using JavaScript?
    10·1 answer
  • A cybersecurity analyst is currently investigating a server outage. The analyst has discovered the following value was entered f
    9·1 answer
  • Discuss whether the redundant data should be addressed prior to beginning the wireless network architecture project, in coordina
    11·1 answer
  • When a project manager can look at the progress towards the goals set, this is considered...?
    11·2 answers
  • Write a method called consecutive that accepts three integers as parameters and returns true if they are three consecutive numbe
    8·1 answer
  • How does one select an entrepreneurial activity?
    9·1 answer
  • Type (dog, cat, budgie, lizard, horse, etc.) Create a class that keeps track of the attributes above for pet records at the anim
    7·1 answer
  • What is an Operating System write its types and describe in short​
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!