Otimizar as consultas do BigQuery para melhorar o desempenho: AVANÇADO avaliações

RAFAEL A. · Revisado há almost 2 years

Pawel P. · Revisado há almost 2 years

Kamil F. · Revisado há almost 2 years

Bruno S. · Revisado há almost 2 years

Charlie G. · Revisado há almost 2 years

sefi r. · Revisado há about 2 years

Julie L. · Revisado há about 2 years

Julie L. · Revisado há about 2 years

Exercise 5 you say the goal is “determine the most common names assigned to both male and female babies in the country over all the years in the dataset” but the initial query inexplicably limits to only year-state combinations where the name was between 30% and 70% male. Where did that come from?! And then the optimized query has different sums because it doesn’t do that group, join, and filter on state and year. I wouldn’t call that optimization, I’d call that correcting a wrong query. This exercise needs another look.

Brian M. · Revisado há about 2 years

Jonathan C. · Revisado há about 2 years

Marcelo G. · Revisado há about 2 years

yugender b. · Revisado há about 2 years

Joyce W. · Revisado há about 2 years

Namita R. · Revisado há about 2 years

very good lab, especially because the answers not in front of u and only at the end.

Hila C. · Revisado há about 2 years

Saar S. · Revisado há about 2 years

Diego R. · Revisado há about 2 years

Carlos Andres F. · Revisado há about 2 years

Carla C. · Revisado há about 2 years

Sindy G. · Revisado há about 2 years

Ana Paula G. · Revisado há about 2 years

Ricardo T. · Revisado há about 2 years

Having no familiarity with origin tables makes this one too hard to complete in one sitting.

Lautaro C. · Revisado há about 2 years

Paloma M. · Revisado há about 2 years

Paloma M. · Revisado há about 2 years