Optimizing your BigQuery Queries for Performance - ADVANCED Reviews

RAFAEL A. · Reviewed почти 2 лет ago

Pawel P. · Reviewed почти 2 лет ago

Kamil F. · Reviewed почти 2 лет ago

Bruno S. · Reviewed почти 2 лет ago

Charlie G. · Reviewed почти 2 лет ago

sefi r. · Reviewed около 2 лет ago

Julie L. · Reviewed около 2 лет ago

Julie L. · Reviewed около 2 лет 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 около 2 лет ago

Jonathan C. · Reviewed около 2 лет ago

Marcelo G. · Reviewed около 2 лет ago

yugender b. · Reviewed около 2 лет ago

Joyce W. · Reviewed около 2 лет ago

Namita R. · Reviewed около 2 лет ago

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

Hila C. · Reviewed около 2 лет ago

Saar S. · Reviewed около 2 лет ago

Diego R. · Reviewed около 2 лет ago

Carlos Andres F. · Reviewed около 2 лет ago

Carla C. · Reviewed около 2 лет ago

Sindy G. · Reviewed около 2 лет ago

Ana Paula G. · Reviewed около 2 лет ago

Ricardo T. · Reviewed около 2 лет ago

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

Lautaro C. · Reviewed около 2 лет ago

Paloma M. · Reviewed около 2 лет ago

Paloma M. · Reviewed около 2 лет ago