Datasource: Web SQL Username: Survey Password: teserwcn Template: conversion.htx SQLStatement: +SELECT + + fte_tenure_9798 + fte_researcher_9798 + fte_postdoc_9798 + fte_other_9798 + fte_instructor_9798 + cs_phd_pr_male + ce_phd_pr_male + cs_phd_pr_female + ce_phd_pr_female + cs_phd_pr_gunknown + ce_phd_pr_gunknown + cs_ms_pr_male + ce_ms_pr_male + cs_ms_pr_female + ce_ms_pr_female + cs_ms_pr_gunknown + ce_ms_pr_gunknown + cs_bs_pr_male + ce_bs_pr_male + cs_bs_pr_female + ce_bs_pr_female + cs_bs_pr_gunknown + ce_bs_pr_gunknown + cs_phd_enr_male + ce_phd_enr_male + cs_phd_enr_female + ce_phd_enr_female + cs_phd_enr_gunknown + ce_phd_enr_gunknown + cs_ms_enr_new + ce_ms_enr_new + cs_bs_enr_new + ce_bs_enr_new + +FROM survey.faculty, survey.phd, survey.ms. survey.bs +WHERE survey.faculty.id = survey.phd.id = survey.ms.id = survey.bs.id AND %rank%