Union Vs Union ALL
UNION and UNION ALL are both used to retrieve records from multiple
Subquery Vs Join
One of the greatest challenges in writing queries is deciding which to