R Notebook

-------------------  Tasa de retención al 1ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M')

------------------  Tasa de retención al 2DO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M')

----------------------------------------------------------------------------
--- DOCT. EN BIOTECNOLOGIA  MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F')

------------------------------------------------------------------------------------------------------------------
--- DOCT. CIENCIA Y TECNOLOG DE LOS ALIMENTOS  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCT. EN CIENCIA Y TECNOLOG DE LOS ALIMENTOS  MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F')

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN CIENCIAS DE LA EDUCACIÓN, MENCIÓN EDUCACIÓN INTERCULTURAL  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN CIENCIAS DE LA EDUCACIÓN, MENCIÓN EDUCACIÓN INTERCULTURAL  MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F')

-------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------
--- DOCT. EN CIENCIAS MENC FÍSICA  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCT. EN CIENCIAS MENC FÍSICA MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F')

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN CIENCIAS DE LA INGENIERIA, CON MENCIÓN INFORMÁTICA  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN CIENCIAS DE LA INGENIERIA, CON MENCIÓN INFORMÁTICA MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN CIENCIAS CON MENCIÓN MATEMÁTICA HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN CIENCIAS CON MENCIÓN MATEMÁTICA MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F')

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN ESTUDIOS AMERICANOS HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN ESTUDIOS AMERICANOS MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F')

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN HISTORIA HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN HISTORIA MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN microbiologia HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN microbiologia MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN neurocien HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN neurocien MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN PSICOLOG HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN PSICOLOG MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN quimica HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN quimica MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN ciencias de la ADMINISTRA  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN ciencias de la ADMINISTRA MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

------------------- Tasa de retención al 5TO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN ciencias DE LA ING  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN ciencias de la ING MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2014 F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2014 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------
--- DOCT. BIOTECNOLOGIA  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M')

------------------  Tasa de retención al 2DO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M')

----------------------------------------------------------------------------
--- DOCT. EN BIOTECNOLOGIA  MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F')

------------------------------------------------------------------------------------------------------------------
--- DOCT. CIENCIA Y TECNOLOG DE LOS ALIMENTOS  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCT. EN CIENCIA Y TECNOLOG DE LOS ALIMENTOS  MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F')

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN CIENCIAS DE LA EDUCACIÓN, MENCIÓN EDUCACIÓN INTERCULTURAL  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN CIENCIAS DE LA EDUCACIÓN, MENCIÓN EDUCACIÓN INTERCULTURAL  MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F')

-------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------
--- DOCT. EN CIENCIAS MENC FÍSICA  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCT. EN CIENCIAS MENC FÍSICA MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F')

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN CIENCIAS DE LA INGENIERIA, CON MENCIÓN INFORMÁTICA  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN CIENCIAS DE LA INGENIERIA, CON MENCIÓN INFORMÁTICA MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN CIENCIAS CON MENCIÓN MATEMÁTICA HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN CIENCIAS CON MENCIÓN MATEMÁTICA MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F')

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN ESTUDIOS AMERICANOS HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN ESTUDIOS AMERICANOS MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F')

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN HISTORIA HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN HISTORIA MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN microbiologia HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN microbiologia MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN neurocien HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN neurocien MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN PSICOLOG HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN PSICOLOG MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN quimica HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN quimica MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN ciencias de la ADMINISTRA  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN ciencias de la ADMINISTRA MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

------------------- Tasa de retención al 5TO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN ciencias DE LA ING  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN ciencias de la ING MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2015  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2015 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------
--- DOCT. BIOTECNOLOGIA  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M')

------------------  Tasa de retención al 2DO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='M')

----------------------------------------------------------------------------
--- DOCT. EN BIOTECNOLOGIA  MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%BIOTEC%' AND SEXO='F')

------------------------------------------------------------------------------------------------------------------
--- DOCT. CIENCIA Y TECNOLOG DE LOS ALIMENTOS  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCT. EN CIENCIA Y TECNOLOG DE LOS ALIMENTOS  MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%CIEN%TECNO%ALIM%' AND SEXO='F')

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN CIENCIAS DE LA EDUCACIÓN, MENCIÓN EDUCACIÓN INTERCULTURAL  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN CIENCIAS DE LA EDUCACIÓN, MENCIÓN EDUCACIÓN INTERCULTURAL  MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%CIEN%EDUCA%INTERCULT%' AND SEXO='F')

-------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------
--- DOCT. EN CIENCIAS MENC FÍSICA  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCT. EN CIENCIAS MENC FÍSICA MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%CIENC%MENC%SICA%' AND SEXO='F')

-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN CIENCIAS DE LA INGENIERIA, CON MENCIÓN INFORMÁTICA  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN CIENCIAS DE LA INGENIERIA, CON MENCIÓN INFORMÁTICA MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%CIEN%INGEN%INFORM%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN CIENCIAS CON MENCIÓN MATEMÁTICA HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN CIENCIAS CON MENCIÓN MATEMÁTICA MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%CIEN%MATEM%' AND SEXO='F')

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN ESTUDIOS AMERICANOS HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN ESTUDIOS AMERICANOS MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%ESTUDI%AMERICA%' AND SEXO='F')

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN HISTORIA HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN HISTORIA MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%HIST%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN microbiologia HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN microbiologia MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%MICROBIOL%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN neurocien HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN neurocien MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%NEUROCIEN%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN PSICOLOG HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN PSICOLOG MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%PSICOLOG%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN quimica HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN quimica MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%QU%MICA%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN ciencias de la ADMINISTRA  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2020 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN ciencias de la ADMINISTRA MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2020  AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

------------------- Tasa de retención al 5TO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019 AND "PLAN" LIKE '%DOCT%CIENCIA%ADMINISTRA' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------
--- DOCTORADO EN ciencias DE LA ING  HOMBRES ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  H -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='M')

-------------------------------------------------------------------------------------------------------------------------------------

--- DOCTORADO EN ciencias de la ING MUJERES  ---
-------------------  Tasa de retención al 1ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2016   AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F')

-------------------  Tasa de retención al 2DO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2017  AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F')

-------------------  Tasa de retención al 3ER año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2018  AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F')

------------------- Tasa de retención al 4TO año --- COHORTE 2016  F -----------------
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F'
SELECT count(DISTINCT RUT) FROM DDI_DATOS.dbo.V_COHORTE_FORMB WHERE ANHO=2016 AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F' AND RUT IN (SELECT RUT FROM DDI_DATOS.dbo.MATRICULA WHERE ANHO=2019  AND "PLAN" LIKE '%DOCT%CIENCIAS%INGENIE%' AND SEXO='F')
-------------------------------------------------------------------------------------------------------------------------------------