Optimizing your BigQuery Queries for Performance - ADVANCED Reviews

RAFAEL A. · Reviewed almost 2 years ago

Pawel P. · Reviewed almost 2 years ago

Kamil F. · Reviewed almost 2 years ago

Bruno S. · Reviewed almost 2 years ago

Charlie G. · Reviewed almost 2 years ago

sefi r. · Reviewed about 2 years ago

Julie L. · Reviewed about 2 years ago

Julie L. · Reviewed about 2 years ago

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. · Reviewed about 2 years ago

Jonathan C. · Reviewed about 2 years ago

Marcelo G. · Reviewed about 2 years ago

yugender b. · Reviewed about 2 years ago

Joyce W. · Reviewed about 2 years ago

Namita R. · Reviewed about 2 years ago

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

Hila C. · Reviewed about 2 years ago

Saar S. · Reviewed about 2 years ago

Diego R. · Reviewed about 2 years ago

Carlos Andres F. · Reviewed about 2 years ago

Carla C. · Reviewed about 2 years ago

Sindy G. · Reviewed about 2 years ago

Ana Paula G. · Reviewed about 2 years ago

Ricardo T. · Reviewed about 2 years ago

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

Lautaro C. · Reviewed about 2 years ago

Paloma M. · Reviewed about 2 years ago

Paloma M. · Reviewed about 2 years ago