Question 1A 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?1 pointORDER BY candle_priceWHERE candle_priceWHERE candle_price ASCORDER BY candle_price DESC

Which statement would you use to query the database for the quantity and description of each item thatwas ordered before June 1, 1999, and whose price is less than 0.25 or greater than 10.00?

2.Question 2A data analyst organizes a database to show only the 100 most recent real estate sales in Stamford, Connecticut. What steps do they take?1 pointAdd a filter to return only sales in Stamford, Connecticut, then sort the most recent sales at the top of the list.Filter out sales in Stamford, Connecticut, then sort the least recent sales at the top of the list.Filter out sales in Stamford, Connecticut, then sort the most recent sales at the top of the list.Add a filter to return only sales in Stamford, Connecticut, then sort the least recent sales at the top of the list.3.Question 3

The price of various food items were entered in adjacent cells on a spreadsheet. Hannah wants to arrange the list of prices in descending order, from highest to lowest. Which of the following step(s) should be followed?1 pointSelect the list of prices and then click the icon labelled " Sort A to Z"Select the lsit of prices and then click the icon labelled " Sort Z to A'Click the icon labelled " Sort A to Z"Click the icon labelled " Sort Z to A"

Question 2In this activity, you practiced sorting data using SQL queries with ORDER BY and filtering data with WHERE clauses. In the text box below, write 2-3 sentences (40-60 words) in response to each of the following questions:How can the ORDER BY clause help you organize and structure your data?Why is it helpful to use the ORDER BY and WHERE clauses together when analyzing data?Describe a business question that you could answer using the ORDER By and WHERE clauses together. How would this method help you answer the question?

The question consists of five statements labeled A, B, C and D which when logically ordered forms a coherent passage. Choose the option that represents the most logical order. A. Food manufactures spend more on advertising than any other manufacturing group and the nation's grocery stores rank first among all retailers. B. Food product lead in expenditures for network and spot television advertisements, discount coupons, trading stamps, contests, and other forms of premium advertising. C. Foods are overwhelming the most advertised group of all consumer products in the U.S. D. In other media- newspapers, magazines, newspaper supplements, billboard and radio, food advertising expenditures rank near the top.Choices:- CDBA CBDA CADB DACB