April 2, 2019 SQL Daily Challenge Response

querry response 1

select id, host_id, host_name, room_type from levelUp.listings where room_type = 'Private room' order By host_name ASC;

querry response 2

Selecting only room_type and price columns:

Select room_type, price from levelUp.listings where price BETWEEN 50 AND 100;



Selecting all columns:

select * from levelUp.listings where price BETWEEN 50 AND 100;

querry response 3

Selecting only room_type and accommodates columns:

select room_type, accommodates from levelUp.listings where room_type = 'Private room' AND accommodates >= 2;




Selecting all columns:

select * from levelUp.listings where room_type = 'Private room' AND accommodates >= 2;

Nice work!