SQL tricks

join

if we want to allow empty in some properties, we should use left join and on.

difference between where and on

where is used to filter data and on is used to join data and should be used when we join two tables.

- operation

MySQL doesn’t support - so if we need n-1, we need another variable to be set.