<> not equal
What is the difference between single and double quotes in SQL?
Single quotes are used to indicate the beginning and end of a string in SQL. Double quotes generally aren’t used in SQL, but that can vary from database to database.
Stick to using single quotes.
[S]ingle quotes are for [S]trings ; [D]ouble quotes are for [D]atabase identifiers;
BETWEEN
It’s important to remember that BETWEEN is inclusive, meaning the beginning and end values are included in the results!
LIKE
- % - The percent sign represents zero, one, or multiple characters
- _ - The underscore represents a single character
NULL
In SQL, NULL represents a missing or unknown value. You can check for NULL values using the expression IS NULL.
Aggregate Functions
MIN(),MAX(),AVG(),SUM()
arithmetic
/SQL assumes that if you divide an integer by an integer, you want to get an integer back. So be careful when dividing!
/ in python will convert to float, no matter whether two values are integer or not.
