Subquery
shape
SELECT, INSERT, UPDATE, or DELETE statements and can help with complex queries where a direct comparison or condition is needed. GROUP BY clause in MySQL is used to group rows that have the same values in specified columns into summary rows, often used with aggregate functions like COUNT(), SUM(), AVG(), MIN(), and MAX() to perform calculations on each group. Essentially, it allows you to aggregate data across multiple rows and summarize it into a smaller set of results.