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

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

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 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.

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 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