Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

Missing join condition in join query produces cartesian product.

COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.