SQL can be a tricky language to use because often times you get results after query execution that may look right but are not. You have to able to think in sets rather than algorithmically. This repo has some tips and techniques on using SQL to execute some popular operations that can be perplexing for many database developers.