SQL - Mid level Part 2

SQL From Basic to Advanced level

Once you know Part 1 Level, take the next step and learn commands like: 

- LEFT JOIN 

- INNER JOIN 

- LIKE 

- IN 

- CASE WHEN 

- HAVING (understand how it's different from GROUP BY) 

- UNION ALL 

This should take another day.