Skip to content

Instantly share code, notes, and snippets.

@duartejr

duartejr/gist.sql

Last active May 29, 2022 18:05
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save duartejr/98b3eca8d6a7e3db763b97520b134e5b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save duartejr/98b3eca8d6a7e3db763b97520b134e5b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gist.sql
SELECT sigla_uf as UF, V2007 AS Genero, V2009 AS Idade, V2010 AS Cor, VD3005 AS Anos_de_Estudo,
VD4020 as Renda
FROM `basedosdados.br_ibge_pnadc.microdados`
WHERE ano = 2021 and V2009 >= 18 and VD4020 >= 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment