Skip to content

Instantly share code, notes, and snippets.

@RelativeTech

RelativeTech/comp-greater-than-500000.sql

Created March 25, 2021 20:35
Show Gist options
  • Save RelativeTech/d92d348443f429f8fdf1df0e7aa24f98 to your computer and use it in GitHub Desktop.
Save RelativeTech/d92d348443f429f8fdf1df0e7aa24f98 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
comp-greater-than-500000.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
having sum(w.compensation) > 500000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment