Zillow Interview Question

some basic SQL questions and later on also asked me to reimplement in a different way