Skip to content

Instantly share code, notes, and snippets.

@Kyeongan

Kyeongan/t_funding.sql

Last active Jul 9, 2016
Embed
What would you like to do?
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
You can’t perform that action at this time.