Question

Write a SELECT statement that returns four columns from the Products table: product_code, product_name, list_price, and discount_percent. Then, run this statement to make sure it works correctly. Add an ORDER BY clause to this statement that sorts the result set by list price in descending sequence. Then, run this statement again to make sure it works correctly. This is a good way to build and test a statement, one clause at a time.

Answer 1

SELECT product_code, product_name , list_price, discount_percent

FROM Products

ORDER BY list_price DESC;

Step-by-step explanation:

Here, we want to write an SQL statement.

Solution is as follows;

SELECT product_code, product_name , list_price, discount_percent

FROM Products

ORDER BY list_price DESC;