Untitled

SELECT
  (SELECT COUNT(1)
   FROM user_info
   WHERE id = 171818 AND has_set_password = 0 AND class_id = 3) +
  (SELECT COUNT(1)
   FROM prof_user_outside_US
   WHERE user_id = 171818) AS is_user_non_us;