Which clause is used for grouping data in SQL queries?

The clause used for grouping data in SQL queries is "GROUP BY". This clause allows you to aggregate and summarize data by combining rows that have the same values in specified columns. When using "GROUP BY", you can apply aggregate functions, such as COUNT, SUM, AVG, MIN, and MAX, to the grouped data, enabling you to perform calculations on each group independently.

For example, if you have a sales table and you want to find the total sales amount for each product, you can use "GROUP BY" with the product name. This will consolidate all sales records for each product into single entries that represent the total sales, making it easier to analyze the data.

On the other hand, "ORDER BY" is used to sort the result set of a query based on one or more columns, while "LIMIT" restricts the number of rows returned by the query. The "WHERE" clause filters records based on specified conditions before any grouping occurs, but it does not group data itself. Thus, "GROUP BY" is the correct choice for organizing data into groups for analysis.