Question 4Which of the following statements accurately describe sorting and filtering? Select all that apply.1 pointSorting involves arranging data into a meaningful order.Filtering can be performed in spreadsheets, but not SQL databases.Sorting can be performed in both spreadsheets and SQL databases.Filtering enables data professionals to view the data that is most important.5.Question 5

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?

Which one of the following construct is used for sorting the data in the result set of SQL queries?

Question 4In what way is the SQL WHERE clause similar to filtering in spreadsheets?1 pointBoth the WHERE clause and spreadsheet filters enable data professionals to remove duplicate columns.Both the WHERE clause and spreadsheet filters enable efficient sorting of data.Both the WHERE clause and spreadsheet filters can be used to create pivot tables.Both the WHERE clause and spreadsheet filters return a subset of data based on specified criteria.

Which of the following are valid sorting orders you can choose when adding sorting levels to your data? Select all that apply.1 pointZ to AOldest to NewestYoungest to Oldest Smallest to Largest

What is the order of operations for filtering data?*