1.3 Sorting data with SQL

A data analyst at a gift retailer sorts a list of handmade candles by price from least expensive to most expensive. Which statement do they use?

A. WHERE candle_price

B. ORDER BY candle_price DESC

C. ORDER BY candle_price

D. WHERE candle_price ASC

C. ORDER BY candle_price

What will this query return?

1 SELECT *

2 FROM widgets

3 ORDER BY

4 manufacture_date DES

A. All of the rows in the widgets table, with the least-recently manufactured widgets listed first

B. All of the rows in the widgets table

C. All of the columns in the manufacture_ date table

D. All of the rows in the widgets table, with the most-recently manufactured widgets listed first

D. All of the rows in the widgets table, with the most-recently manufactured widgets listed first

You are working with a database table that contains employee data. Which ORDER BY clause will sort employees by the earliest hire dates at the top of the list?

A. ORDER BY hire_date ASC

B. ORDER BY hire_date DESC

C. ORDER BY hire_date REV

D. ORDER BY hire_date MIN

A. ORDER BY hire_date ASC

What SQL operator enables a data professional to filter for two conditions at once when using a WHERE statement?

A. IN

B. Plus sign +

C. AND

D. Ampersand &

C. AND