关于“Optimizing your BigQuery Queries for Performance - ADVANCED”的评价

RAFAEL A. · 已于 almost 2 years前审核

Pawel P. · 已于 almost 2 years前审核

Kamil F. · 已于 almost 2 years前审核

Bruno S. · 已于 almost 2 years前审核

Charlie G. · 已于 almost 2 years前审核

sefi r. · 已于 about 2 years前审核

Julie L. · 已于 about 2 years前审核

Julie L. · 已于 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. · 已于 about 2 years前审核

Jonathan C. · 已于 about 2 years前审核

Marcelo G. · 已于 about 2 years前审核

yugender b. · 已于 about 2 years前审核

Joyce W. · 已于 about 2 years前审核

Namita R. · 已于 about 2 years前审核

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

Hila C. · 已于 about 2 years前审核

Saar S. · 已于 about 2 years前审核

Diego R. · 已于 about 2 years前审核

Carlos Andres F. · 已于 about 2 years前审核

Carla C. · 已于 about 2 years前审核

Sindy G. · 已于 about 2 years前审核

Ana Paula G. · 已于 about 2 years前审核

Ricardo T. · 已于 about 2 years前审核

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

Lautaro C. · 已于 about 2 years前审核

Paloma M. · 已于 about 2 years前审核

Paloma M. · 已于 about 2 years前审核