Re: Newbie Help

[Peter Brawley]

drop table if exists t;
create table t(hotel char(1),roomtype char(8));
insert into t values('a','single'),('a','double'),('b','single'),('c','suite');

select hotel
from t
where roomtype in('single','double')
group by hotel
having count(distinct roomtype) = 2;
+-------+
| hotel |
+-------+
| a     |
+-------+