Skip to content

Instantly share code, notes, and snippets.

@beckyconning
Last active January 29, 2016 23:17
Show Gist options
  • Save beckyconning/0c5d0c4ef91bf1f9fa60 to your computer and use it in GitHub Desktop.
Save beckyconning/0c5d0c4ef91bf1f9fa60 to your computer and use it in GitHub Desktop.

discipline = __ (!SELECT discipline FROM "/testDb/olympics" LIMIT 1) year = __ (!SELECT year FROM "/testDb/olympics" LIMIT 1) country = {!SELECT DISTINCT country FROM "/testDb/olympics"} (!SELECT country FROM "/testDb/olympics" LIMIT 1) type = (!SELECT DISTINCT type FROM "/testDb/olympics" LIMIT 1) !SELECT DISTINCT type FROM "/testDb/olympics" OFFSET 1 gender = [!SELECT gender FROM "/testDb/olympics" LIMIT 1] !SELECT DISTINCT gender FROM "/testDb/olympics"

SELECT * FROM "/test-mount/testDb/olympics" WHERE discipline = :discipline AND type != :type AND gender IN :gender AND year > :year AND country = :country
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment