In real world analytics, data rarely exists in isolation, rather it is usually stored in separate but related tables. Extracting meaningful insights from these related tables usually require more advanced SQL concepts like;


Joins: which allow you to combine data from multiple tables.
Window functions: allow you to perform calculations across...