SELECT address ,  num_of_staff FROM shop WHERE shop_id NOT IN (SELECT shop_id FROM happy_hour)
Find the address and staff number of the shops that do not have any happy hour.
SELECT address , num_of_staff FROM shop WHERE shop_id NOT IN ( SELECT shop_id FROM happy_hour )
select address , num_of_staff from shop where shop_id not in ( select shop_id from happy_hour )
Find the address and staff number of the shops that do not have any happy hour .