What does the GROUP BY statement do in SQL?Groups rows that have the same values in specified columns into aggregated dataGroups tables that have the same columnsGroups database users that have the same privilegesNone of the above

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

The GROUP BY clause indicatesthe list of row conditions.the list of row summary conditions.the list of aggregate functions.the list of grouping columns for calculation of aggregate functions.

Which of the following statements is TRUE about grouping in SQL?You can only group by one column at a time.Grouping automatically sorts the results.You can use aggregate functions directly in the SELECT clause without grouping.Grouping allows you to summarize data based on shared characteristics.

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.