Write a select statement that returns four columns from the products table: productcode, productname, listprice, and discountpercent. 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.