select restaurant_id FROM schedule WHERE DATEPART(hh, GETDATE()) - DATEPART(hh, first_pickup) = (SELECT name,
  CASE time_zone
	when 'Eastern Time' Then 0
	when 'Central Time' Then -1
	when 'Mountain Time' Then -2
    when 'Pacific Time' Then -3
  end
FROM restaurant)