Skip to content

Instantly share code, notes, and snippets.

@Kyeongan

Kyeongan/t_funding.sql

Last active July 9, 2016 21:02
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 Kyeongan/de87851e3651afb6882b4294c0a7554a to your computer and use it in GitHub Desktop.
Save Kyeongan/de87851e3651afb6882b4294c0a7554a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
t_funding.sql
SELECT t_funding, mean_IF
FROM
(
SELECT google_id, name, h_index, min_year, max_year,
t_citations, max_citations, num_journals, mean_IF,
max_IF, num_grants, t_funding, t_deflated_funding, a.department, b.discipline
FROM s_faculty a INNER JOIN dept_disciplines b
ON a.department = b.department
) c
WHERE c.discipline =
( SELECT discipline
FROM dept_disciplines
WHERE department ='" . $dept . "' LIMIT 1
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment