What is the purpose of the SQL GROUP BY clause?OptionsTo join two or more tablesTo sort rows in a tableTo filter rows from a tableTo group rows with the same values into summary rows

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 SQL HAVING clause?OptionsTo join two or more tablesTo sort rows in a tableTo filter rows from a tableTo filter rows after grouping

What does the SQL command 'GROUP BY' do?Groups rows that have identical values into summary rowsSorts the data in ascending orderFilter rows based on specified conditionsPerforms arithmetic calculations on numeric columns

What is the purpose of the SQL JOIN operation?OptionsTo combine rows from two or more tables based on a related column between themTo filter rows based on a specified conditionTo group rows based on a common attributeTo sort the result set in ascending order

What does the GROUP BY clause in SQL achieve?Sorts data in ascending or descending order.Groups rows based on a specified column, allowing for aggregate functions.pen_sparkFilters rows based on a specific condition.Selects specific columns from a table.