Skip to content

Instantly share code, notes, and snippets.

@YiLi225

YiLi225/logical_par.sql

Last active December 4, 2020 04:33
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/752ce1717174dc9e5866d572d82fc6e5 to your computer and use it in GitHub Desktop.
Save YiLi225/752ce1717174dc9e5866d572d82fc6e5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
logical_par.sql
/** 4.2 User logins in NYC and in Year 2018 or Num_Var >= 1000 -- parenthesis **/
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