Once your SQL is ready, it is essential to test that it actually returns the expected result.

Create sample data for each condition checked by your SQL. Then execute the SQL and make sure it returns the expected result for each case.