Can you provide me with the most common apartment type code among all of the apartments with at least 1 bathroom?
SELECT apt_type_code FROM Apartments WHERE bathroom_count   > =    1 GROUP BY apt_type_code ORDER BY count ( * )  DESC LIMIT 1
most common apartment type code = MAX(COUNT(apt_type_code)); apartments with at least 1 bathroom refers to bathroom_count >= 1;