Mastering SQL: A Student's Guide

`ORDER BY`

`GROUP BY`

`WHERE`

`HAVING`

`SELECT * FROM students;`

`GET ALL FROM students;`

`FETCH ALL FROM students;`

`RETRIEVE * FROM students;`

To delete records from a table

To combine rows from two or more tables based on a related column

To update records in a table

To create a new table

It selects all columns from the `employees` table where the department is 'Sales'.

It selects the `name` column from the `employees` table where the department is 'Sales'.

It updates the `name` column in the `employees` table to 'Sales'.

It deletes records from the `employees` table where the department is 'Sales'.

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL JOIN

It counts the number of employees in each department.

It adds all employees from each department showing the total.

It updates the department count in the `employees` table.

It deletes departments with no employees.