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
givi [52]
2 years ago
6

Write a SELECT statement that returns these columns from the Customers table:

Computers and Technology
1 answer:
Nastasia [14]2 years ago
3 0

Answer:

SELECT customer_last_name, customer_city, customer_zip FROM customers WHERE customer_state = 'IL' ORDER BY customer_last_name DESC;

Explanation:

Here, we are given a SCHEMA with the table name customers.

It's creation command and commands to insert values are also given.

We have to print the customer last name, city and zip code of all the customers who have their state as IL in the decreasing order of their last names.

Let us learn a few concepts first.

1. To print only a specified number of columns:

We can write the column names to be printed after the SELECT command.

2. To print results as per a condition:

We can use WHERE clause for this purpose.

3. To print in descending order:

We can use ORDER BY clause with the option DESC to fulfill the purpose.

Therefore, the answer to our problem is:

SELECT customer_last_name, customer_city, customer_zip FROM customers WHERE customer_state = 'IL' ORDER BY customer_last_name DESC;

Output of the command is also attached as screenshot in the answer area.

You might be interested in
_____ allows you to use the internet for making phone calls instead of leasing traditional telephone lines from the phone compan
TEA [102]
Using a browser would help in doing that.
3 0
3 years ago
Which of the following is true of functions?
Anna11 [10]

Answer:

the answer is D

Explanation:

4 0
3 years ago
The incompatibilities in speed between the various devices and the CPU make I/O synchronization difficult, especially if there a
Iteru [2.4K]

Answer:

In a buffer

Explanation:

We can define a buffer as a temporary holding area for data between the various devices and the CPU make I/O synchronization especially if there are multiple devices attempting to do I/O at the same time.

Items stored at the buffer helps to reduce the The incompatibilities in speed between the various devices and the CPU.

3 0
3 years ago
As part of their extensive kitchen remodel, the Lees told their electrical contractors that they would need plenty of outlets fo
Vanyuwa [196]

The kind of wire and circuit breaker are:  grounding wire such as fairly large bare copper wire.

<h3>What is the best wire for the above?</h3>

A 20A, 120V small-appliance branch circuit is known to be  used in the case above.

Note that Electric range circuits needs about 50-amp, 240-volt made for circuit that is said to supplies the power to the range or oven via  a 6-3 electrical wire.

Learn more about circuit breaker from

brainly.com/question/8976395

#SPJ1

5 0
2 years ago
Where are my files shortcut in documents folder.
faust18 [17]

Answer: Search File Explorer: Open File Explorer from the taskbar or right-click on the Start menu, and choose File Explorer, then select a location from the left pane to search or browse. For example, select This PC to look in all devices and drives on your computer, or select Documents to look only for files stored there.

Explanation: hope this helps :)

4 0
2 years ago
Other questions:
  • Once the technology for the collection of solar power is in place what will be two benefits of its use
    9·1 answer
  • Prewritten, commercially available sets of software programs that eliminate the need for a firm to write its own software progra
    5·1 answer
  • A blank is a link on a web page that leads to another web page.
    14·1 answer
  • After adding an email account, how do you switch accounts to send a message?
    10·2 answers
  • _____ remove the part of an image starting from an edge​
    13·1 answer
  • 1. Implement the function dict_intersect, which takes two dictionaries as parameters d1 and d2, and returns a new dictionary whi
    8·1 answer
  • BRAINLIEST!!! 20 PNTS!!!! HELPP!!!
    12·1 answer
  • Add the following method to the Point class: public double distance(Point other) Returns the distance between the current Point
    12·1 answer
  • Explain how files can be identified as entities on the magnetic surface?
    8·1 answer
  • Is it true that if the user log out the computer will turn off automatically​
    9·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!