Skip to content

Instantly share code, notes, and snippets.

@alexandre-mbm
Created April 30, 2016 05:24
Show Gist options
  • Save alexandre-mbm/6fd18d82a7659278576c946e662db202 to your computer and use it in GitHub Desktop.
Save alexandre-mbm/6fd18d82a7659278576c946e662db202 to your computer and use it in GitHub Desktop.
Tentando prever resultado final de concurso
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment