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 ...

SQL CASE and ... dynamic and flexible queries that can handle different scenarios and values, as well as simplify your queries by avoiding multiple or nested queries or joins.

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), ...