In SQL, which clause is used to specify a condition for grouping rows?Options HAVINGGROUP BYORDER BYWHERE

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

In SQL, which clause is used to filter rows from a table?OptionsSORT BYWHEREGROUP BYFILTER

Which SQL clause is used to filter rows based on specified conditions?GROUPFILTERWHEREHAVING

What is the purpose of the SQL HAVING clause?OptionsTo filter rows from a tableTo sort rows in a tableTo filter rows after groupingTo join two or more tables

Which SQL clause is used to specify the order of rows in a result set?OptionsHAVINGORDER BYSORTGROUP BY