Mastering MySQL Query Outputs

What is the purpose of the SELECT statement in SQL?

• To update existing records in a database.

• To delete data from a database.

• To retrieve data from a database.

• To create new tables in a database.

How does the GROUP BY clause affect the output of a query?

• The GROUP BY clause limits the number of rows returned by the query.

• The GROUP BY clause sorts the results in ascending order.

• The GROUP BY clause filters out duplicate rows from the result set.

• The GROUP BY clause groups rows with the same values and allows for aggregate calculations.

What is the function of the WHERE clause in filtering data?

• The WHERE clause filters data based on specified conditions.

• The WHERE clause sorts data in ascending order.

• The WHERE clause joins multiple tables together.

• The WHERE clause groups data into categories.

How does the ORDER BY clause change the order of results?

• The ORDER BY clause filters results based on specific criteria.

• The ORDER BY clause changes the order of results by sorting them based on specified columns in ascending or descending order.

• The ORDER BY clause groups results into categories based on their values.

• The ORDER BY clause removes duplicate results from the output.

What are aggregate functions and how are they used in SQL?

• Aggregate functions are only applicable to text data types in SQL.

• Aggregate functions are used in SQL to perform calculations on a set of values, returning a single value, often used with GROUP BY.

• Aggregate functions return multiple values for each row in a query.

• Aggregate functions are used to create new tables in SQL.