How many unique apartment type codes are there?
select count(distinct apt_type_code) from apartments
What is the minimum room count for the departments?
select min(room_count) from apartments
What is the minimum bathroom count for the departments?
select min(bathroom_count) from apartments
How many apartments have more than 2 bathrooms?
select count(*) from apartments where bathroom_count > 2
How about more than 1?
select count(*) from apartments where bathroom_count > 1
Among those apartments, which apartment type is the most popular one?
select apt_type_code from apartments where bathroom_count > 1 group by apt_type_code order by count(*) desc limit 1