SQL Interview Tips

Quick tips to keep in mind when solving SQL interview questions.

Quick revision on SQL Commands - https://www.programiz.com/sql/commands

Interview SQL Questions Tips

• If question have an aggregator use like, count, sum or avg with group, try to think use of Having clause
• Remember to use LEFT JOIN if null is to be included in join
• If need to include or filter multiple values of a column, like from columns STATUS: confirmed, in-progress, both are to be filtered, consider using IN operator