Skip to content

Instantly share code, notes, and snippets.

@alexandre-mbm

alexandre-mbm/cuidador.sql

Created April 30, 2016 05:24
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save alexandre-mbm/6fd18d82a7659278576c946e662db202 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save alexandre-mbm/6fd18d82a7659278576c946e662db202 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. alexandre-mbm created this gist Apr 30, 2016.
    17 changes: 17 additions & 0 deletions cuidador.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,17 @@
    SELECT
    "objetivas"."matricula" "matricula",
    "objetivas"."nome" "nome",
    "objetivas"."nascimento" "nascimento",
    "objetivas"."nota" "nota1",
    "discursiva"."nota" "nota2",
    "objetivas"."nota" + "discursiva"."nota" "pontos",
    "objetivas"."esp" "especificos",
    "objetivas"."leg" "legislacao",
    "objetivas"."port" "portugues"
    FROM
    "objetivas" "objetivas", "discursiva" "discursiva"
    WHERE
    "objetivas"."matricula" = "discursiva"."matricula"
    ORDER BY
    "pontos" DESC, "especificos" DESC, "nota2" DESC, "legislacao" DESC, "portugues" DESC, "nascimento" ASC
    LIMIT 160