Skip to content

Instantly share code, notes, and snippets.

@RelativeTech

RelativeTech/join1.sql

Created March 25, 2021 20:34
Show Gist options
  • Save RelativeTech/5c8175df3a0f3a29c4ffda5e1c8489dc to your computer and use it in GitHub Desktop.
Save RelativeTech/5c8175df3a0f3a29c4ffda5e1c8489dc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
join1.sql
select p.project_id, sum(w.compensation) as TotalComp
from worker w, project_worker_map p
where = p.worker_id
group by project_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment