Skip to content

Instantly share code, notes, and snippets.

@YiLi225

YiLi225/logical.sql

Created Nov 29, 2020
Embed
What would you like to do?
/** 4. User logins in NYC and in Year 2018 or Num_Var >= 1000**/
SELECT *
FROM
userlogin
WHERE
location_var = 'NYC'
AND YEAR(date_var) = '2018'
OR num_var >= 1000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment