What is the purpose of the WHERE clause in a SQL query?Select one:a. To specify the order of the resultsb. To group rows into subsetsc. To specify the columns to be retrievedd. To filter rows based on a condition

What is the purpose of the WHERE clause in an SQL statement?To specify the columns to be retrievedTo specify the table to be queriedTo filter records based on specified conditionsTo sort the retrieved data

___________ clause is used to retrieve data from one or more tables?Select one:WhereOrder bySelectHaving

What is the purpose of the GROUP BY clause in SQL?OptionsTo filter rows based on a specified conditionTo group rows based on a common attributeTo join two or more tablesTo sort the result set in ascending order

What is the purpose of the ORDER BY clause in an SQL statement?To filter records based on specified conditions To sort the retrieved dataTo group recordsTo limit the number of records retrieved

What is the purpose of the ORDER BY clause in a SQL SELECT statement?To specify which columns to retrieve from the table.To filter rows based on a specified condition.To group rows with the same values into summary rows.To sort the results in ascending or descending order.