Zip Co interview question

Standard behavioral, write SQL queries that were mostly joins