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
1. Which of the following describes a way of memorizing a poem using a mnemonic device?
xenn [34]

Answer:

Singing the words of the poem to the tune of Happy Birthday"

Explanation:

Mnemonic devices are those tools which can be used to improve a persons ability to remember something efficiently. In short, it a technique to memorize something in short period of time and remember it for longer period of time.

Memorizing a poem by singing it to the tune of Happy birthday is also a technique to remember the poem and memorizing it efficiently.

3 0
3 years ago
How can one become a world scientist?
Lynna [10]
No need to woory abt age !!! In today's competitive grant world, this phenomenon is exacerbated. It is dangerous to one's funding to go against the trend, and if there is a lab to support and mouths to feed, the disincentives are great. This phenomenon stifles creativity, perhaps far more than biological age does. 
<span>While it is not frequently acknowledged either in the popular press or in scientific literature, a significant fraction of scientific discovery is the result of serendipity (or to put it more bluntly, luck). From the discovery of penicillin by Fleming to the discovery of new ionization techniques such as MALDI that power modern mass-spectrometry based proteomic research, luck has frequently played a big role. Such discoveries are generally attributed to hard work and genius, rather than to luck. Doing so gives the “genius” too much credit and luck too little.
</span><span>Risk taking is where most of the big discoveries in science lie. so takerisks.
</span>enjoy  always specially when you r  working and learn to say no
Learning to say “no” is particularly important for young faculty, who find themselves barraged with such requests, and who can easily get sucked into full-time committee duties. It is wise to step back frequently and ask, “overall, is this work I am doing fun?” If the answer is no, perhaps it is time to revisit and consider diving into a new area.
<span>Note the distinction in this guideline from: “learn to write and present well.”
</span><span>Understanding and conveying the big picture for one's work is perhaps the greatest challenge facing young scientists
</span>That's all I can give.
8 0
3 years ago
Read 2 more answers
A(n) _____________ is a program used to create and implement a database. operating system database management system information
Anika [276]

The program used to create and implement a database is called an operating system.

<h3>What is an operating system?</h3>

An operating system (OS) is a system that helps to manage and allocate computer resources. These computer resources are:

  • Central processing unit (CPU),
  • Computer memory,
  • File storage,
  • Input/output devices,
  • Network connections.

The most used operating system are;

  • Apple mac OS,
  • Microsoft Windows,
  • Go-ogle Android OS,
  • Lin-ux Operating System,
  • Apple iOS

Learn more about operating system:

brainly.com/question/24032221

5 0
2 years ago
Abigail is writing an email to Justine Swenson, a friend of her best friend, Jane, inviting her to a get-together. Which is the
joja [24]
Use the subject box then write the details in the message box
4 0
3 years ago
Advantages of communications​
poizon [28]

Answer:

promotes team building

creates better relationship

3 0
3 years ago
Read 2 more answers
Other questions:
  • Change control in application development is a formal process for changing written documentation into online documentation, and
    13·1 answer
  • 2. Imagine you play a game of fetch with the dog. It takes the dog 60 seconds to run a total of 180 meters. What was the dog's a
    6·1 answer
  • Describe an application where a parallel circuit might work better than a series circuit.
    15·1 answer
  • Describe Relational Query Languages and Operations.
    15·1 answer
  • What is project management? A. Brainstorming ways to plan a project B. Executing, completing, and revising a project C. Managing
    10·1 answer
  • Select the correct navigational path to create a combination chart. Select the chart. Click the Chart Tools tab. Select the data
    7·1 answer
  • I need neveahbowe to see this.
    10·1 answer
  • Qué propiedades del bromato de potasio han hecho que sea el aditivo más usado en la fabricación del pan​
    8·1 answer
  • A person's oral communication skills can give either a positive or negative first impression.
    12·1 answer
  • How do you modify WordArt? Give specific details and steps<br><br> NEED THIS ASAP
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!