How would you write efficient SQL queries to join complex tables and clean messy marketing data for Microsoft?