column rest_name format a20 tru
column rest_str_addr format a15 tru

-- which restaurants serve burgers AND pizza?

prompt Restaurants that serve burgers AND pizza:
prompt ==========

select rest_name
from   restaurant
where  has_pizza = 'y' 
       and has_burgers = 'y';

-- phone numbers of restaurants that serve pizza?

prompt phone numbers of restaurants that serve pizza:
prompt ==========

select rest_name, rest_phone
from   restaurant
where  has_pizza = 'y';

-- addresses of burger places? 

prompt addresses of burger places:
prompt ==========

select rest_name, rest_str_addr, rest_city
from   restaurant
where  has_burgers = 'y';

-- restaurants in Eureka that serve sandwiches?

prompt restaurants in Eureka that serve sandwiches
prompt ==========

select rest_name, rest_city
from   restaurant
where  rest_city = 'Eureka'
       and has_sandwiches = 'y';