Skip to content

Instantly share code, notes, and snippets.

@ldenson11

ldenson11/joins.sql Secret

Created October 28, 2019 18:14
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 ldenson11/0779674d354e677fe1bb717485244917 to your computer and use it in GitHub Desktop.
Save ldenson11/0779674d354e677fe1bb717485244917 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
joins.sql
SELECT us_west.user_score+ap_south.user_score
FROM kafka_in_zone_us_west us_west
FULL OUTER JOIN kafka_in_zone_ap_south ap_south
ON us_west.user_id = ap_south.user_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment