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
True [87]
3 years ago
9

Find all supplier names and cities who supply expensive chairs, where expensive chairs are those whose selling price is greater

than $300. Keep in mind this question is about chairs only, not the entire furniture line.(5)
Computers and Technology
1 answer:
Gnesinka [82]3 years ago
6 0

Answer:

select s.sname from supplier s,product p,supply su where s.s#=su.s# and p.p#=su.p# and p.p_name like 'chairs' and p.price>300

Explanation:

First of all, we need to select all the required columns from the specific tables so that the data in those columns can be display by executing this SQL query.

As the task at hand is to find all supplier names and cities who supply expensive chairs therefore we need to join three tables in order to look for the supplier name selling the highest prices.

In the above SQL query, the conditons "s.s#=su.s# and p.p#=su.p#" will join tables and the conditons "p.p_name like 'chairs' and p.price>=300" will be used to search for the chair with price greater than $300.

You might be interested in
3) An example of interactive web page is<br>​
FinnZ [79.3K]

Answer:

face book is an interactive website, because you can interact with the content such as give a like or comment.

6 0
3 years ago
18. WHICH MENU WOULD MOST LIKELY ALLOW YOU TO ADJUST YOUR LINE SPACING? *
Natali [406]

Explanation:

FORMAT

because it is used for the general appearance of the page

6 0
3 years ago
The local library dealing with a major computer virus checked its computers and found several unauthorized programs, also known
Dvinal [7]

Answer:

malware

Explanation:

7 0
3 years ago
Read 2 more answers
Do you believe that oop should be phased out and we should start working on some alternative?
Ksju [112]
I don’t think we should because we all have our one choices that we should achieved and we should show
5 0
3 years ago
RFID can be used for all of the following applications except:_________.
serious [3.7K]

Answer:

B. Access point repeater

Explanation:

RFID can be used for all of the listed applications except for Access point repeater. This is because Radio Frequency Identification is a technology, which includes wireless data capture and transaction processing for both short and long-range applications. Usually tracking, tracing, accessing, and managing information. It can unfortunately not be used for repeating the same RFID signal or any access point for that matter.

3 0
3 years ago
Other questions:
  • What might the purpose be for a sata-style power connector on a motherboard?
    15·1 answer
  • Which of these can be considered data?<br> A:facts<br> B:information<br> C:belief<br> D:all of these
    9·1 answer
  • Identify possible advantages and disadvantages of using automatic withdrawal to pay bills
    12·2 answers
  • Can multiple processors can be installed in a single processor housing?
    14·2 answers
  • Refer to the exhibit. If a hacker on the outside network sends an IP packet with source address 172.30.1.50, destination address
    11·1 answer
  • An element in an array is 4 bytes long and there are 10 elements in the array. How big is the array?
    6·2 answers
  • What's another word for contact print?
    15·2 answers
  • Even if you cannot afford it you should donate at least 5 of your earnings to charity true or false
    8·1 answer
  • Which of the following activities does an effective team do?
    15·2 answers
  • Which is NOT true?<br> 9 + 4 = 17 - 4<br> 8 + 7 = 14 + 3<br> 11 = 19 - 8<br> 5 + 8 = 20 - 7
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!