Realtor.com Interview Question

Two SQL queries using group by