Which clause is used to "group rows together by common columns values"?

Solution (By Examveda Team)

This question is about how to organize data in a MySQL database. Imagine you have a table with information about different fruits, like their color, size, and type.

You want to see how many fruits are of each color. The GROUP BY clause lets you do just that! It groups rows with the same color value together so you can count them easily.

Here's how the options work:

Option A: SELECT - This clause is used to choose which columns you want to see in your results.
Option B: GROUP BY - This is the correct answer. It groups rows based on the values of the columns you specify.
Option C: FROM - This clause tells MySQL which table to get the data from.
Option D: WHERE - This clause is used to filter the data, showing only rows that meet certain conditions.

So, if you want to group rows together based on common values, the GROUP BY clause is the way to go!