Skip to content

Instantly share code, notes, and snippets.

@RelativeTech

RelativeTech/w-o-aliases.sql

Created March 25, 2021 20:36
Show Gist options
  • Save RelativeTech/47b2e2bdc5673c29810cac5710413b99 to your computer and use it in GitHub Desktop.
Save RelativeTech/47b2e2bdc5673c29810cac5710413b99 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
w-o-aliases.sql
select project_worker_map.project_id, sum(worker.compensation)
from worker, project_worker_map
where worker = project_worker_map.worker_id
group by project_id
having sum(worker.compensation) > 500000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment