1) In the SELECT clause, you list the fields that you want to display; the order of the list is the order of display. a. True b. False Tables from which you are retrieving data should be in the WHERE clause. a. True b. False There are two compound conditions - AND, OR Ca. True b. False When using the AND condition, only one simple condition must be true for the compound condition to be true. Ca. True b. False The BETWEEN operator is an alternative to using some of the relational operators. a. True b. False The IN operator will allow you to choose from a given set of choices. a. True b. False The ORDER BY clause will permanently sort the original table. Ca. True b. False The output from a SELECT can only be ordered (sorted) by one key. a. True b. False In order to calculate sales for each sales rep. you need to group the customers together for each sales rep. a. True b. False You can use the GROUP BY clause and the ORDER BY clause in the same SELECT statement. a. True b. False (Ctrl)