Skip to content

Instantly share code, notes, and snippets.

@montrealist

montrealist/tinder.sql

Last active December 30, 2020 19:58
Show Gist options
  • Save montrealist/3846146a3f10653dc87dc02183a79b63 to your computer and use it in GitHub Desktop.
Save montrealist/3846146a3f10653dc87dc02183a79b63 to your computer and use it in GitHub Desktop.
Download ZIP
sql join on tinder like site
Raw
tinder.sql
select evalutions.shownId
from evalutions
inner join evalutions as OtherEvaluations
on evalutions.uid = OtherEvaluations.shownId
and OtherEvaluations.res = yes
where evalutions.uid = 'K' and evalutions.res = yes
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment