Simple SQL Performance Tips

Most Prodiminent skill to consume data is sql.From data scientist to ELT developer the most demanded skill is sql.here a few i came across and felt useful.

#1. Avoid subquery in where Clause.

#2 group by use the largest unique entries /values