How do you write joins, subqueries, and aggregate functions to pull specific marketing lists or performance data?