Mastering Database query of complex table

gistfile1.txt

List out host who offer private rooms services only and arrange the results in ascending order by host name.
SELECT host_name FROM levelup_temitope.listings WHERE room_type ="Private room" ORDER BY host_name ASC;

List out rooms whose prices range between 50 and 100
SELECT room_type FROM levelup_temitope.listings WHERE price BETWEEN 50 AND 100;

List out private rooms that can accommodate 2 or more people.
SELECT room_type FROM levelup_temitope.listings WHERE room_type= "Private room" AND accommodates >=2;