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

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