Skip to content

Instantly share code, notes, and snippets.

@YiLi225

YiLi225/IN_operator.sql

Last active Nov 28, 2020
Embed
What would you like to do?
/** 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