Quiz on SQL JOIN with GROUP BY

What is the purpose of using GROUP BY with JOIN in SQL?

Which of the following is a valid SQL query with JOIN and GROUP BY?

In what order do the SQL clauses appear in a JOIN with GROUP BY query?

What must be true about columns in the SELECT clause when using GROUP BY?

Which function is commonly used with GROUP BY after JOIN?

What does this query do?

SELECT c.city, COUNT(o.order_id)
FROM customers c
JOIN orders o ON c.id = o.customer_id
GROUP BY c.city;

What is the output of this query?

SELECT dept.name, AVG(emp.salary)
FROM emp
JOIN dept ON emp.dept_id = dept.id
GROUP BY dept.name;

What does GROUP BY do after a JOIN?

Which clause is used to filter after GROUP BY?

Which of the following is true when using JOIN and GROUP BY together?

Can you group by a column from a joined table?

What does this query output?

SELECT c.name, COUNT(*)
FROM customers c
JOIN orders o ON c.id = o.customer_id
GROUP BY c.name
HAVING COUNT(*) > 5;

Which clause comes first logically during query execution?

Why might a JOIN with GROUP BY return fewer rows than expected?

What will happen if SELECT includes columns not in GROUP BY or in an aggregate function?