Subqueries are queries ... For example, some DBMSs support different syntax, functions, or operators for subqueries and joins. You should be aware of these differences and follow the SQL standards ...

The project will therefore cover all SQL queries, including nested, inner join, group by, distinct ... and then converting it back out again). A typical example: a Wave user deposits some cash into ...

force query plan builder to use nested loop first, just for testing purpose /* we can see that Cost got increased. So main take away is when we are using any kind of joins (especially, Nested Loop), ...