Lyft Interview Question

SQL question - walk through thought process, and write out query