Skip to content

Instantly share code, notes, and snippets.

@YiLi225

YiLi225/logical.sql

Created November 29, 2020 16:52
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/03950a60193f384960e5d80a8899f7df to your computer and use it in GitHub Desktop.
Save YiLi225/03950a60193f384960e5d80a8899f7df to your computer and use it in GitHub Desktop.
Download ZIP
Raw
logical.sql
/** 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