Which SQL join returns only the rows that have matching values in both tables?

Which SQL clause is used to filter groups produced by aggregation?

The SQL DISTINCT keyword is used to:

The SQL GROUP BY clause is used to:

Data Definition Language (DDL) statements are used to:

The SQL GRANT statement is part of which category of SQL commands?

A subquery in SQL is: