SQL LEFT JOIN clause is used to select all the matched records from the left side table, regardless if it has matched records in the right side table or not.
SQL INNER JOIN clause is used to select data from 2 (or more) tables, at least one match in both tables.
SQL Alias is used to organize the output, to make it easy to read and more meaningful. SQL Alias can be used with database tables or database table columns.
The SQL HAVING clause is similar to SQL WHERE clause. The difference is that the SQL HAVING clause is used in aggregate functions but the SQL WHERE clause cannot be used in aggregate functions.
The SQL BETWEEN operator is used to select data within a range between 2 values.
The SQL IN operator is used to search from a list of values in an SQL WHERE clause. The list could be the result of an SQL SELECT query.
SQL LIKE operator is used to search a table column based on a pattern.
The SQL GROUP BY statement is used along with the aggregate functions to group the result dataset by one or more database table columns.
The SQL NOT operator is used to invert the result of an expression.
Truth table for SQL NOT: