MUST KNOW SQL FUNCTIONS!!
The COALESCE() function in SQL is used to return the first non-null value in a list of expressions.
The CASE WHEN statement in SQL is a conditional expression similar to the “if-then” statement in other programming languages.
The ROW_NUMBER function allows for assigning a rank to the rows based on the values in a particular column.