Skip to content

Instantly share code, notes, and snippets.

@YiLi225

YiLi225/IN_operator.sql

Last active November 28, 2020 18:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save YiLi225/18cff9cec6defc4b24c9637a20f37ed8 to your computer and use it in GitHub Desktop.
Save YiLi225/18cff9cec6defc4b24c9637a20f37ed8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
IN_operator.sql
/** 1. User logins in both NYC and Illinois **/
SELECT
DISTINCT id_var, user_var
FROM
userlogin
WHERE
location_var IN ('NYC', 'Illinois')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment