Can you list the apartment type code for each entry?
select apt_type_code from apartments
Can you add to the table the room count for each entry?
select apt_type_code,room_count from apartments
Yes, only for those entries with the highest room count.
select apt_type_code,room_count from apartments order by room_count desc limit 1
Sorry, I think I misunderstood the question. Can you display only the apartment type codes again for each entry?
select apt_type_code from apartments
Can you add up the room counts for each distinct apartment type code and display those values along with their respective department type codes?
select apt_type_code, sum ( room_count ) from apartments group by apt_type_code
Amazing! Can you do add up the bathroom counts and bedroom counts for the department type Flat and add those to the table?
select apt_type_code, sum ( room_count ), sum ( bathroom_count ) ,sum ( bedroom_count ) from apartments where apt_type_code = "Flat"