Optimizing your BigQuery Queries for Performance - ADVANCED Reviews

RAFAEL A. · Reviewed ما يقرب من سنتين ago

Pawel P. · Reviewed ما يقرب من سنتين ago

Kamil F. · Reviewed ما يقرب من سنتين ago

Bruno S. · Reviewed ما يقرب من سنتين ago

Charlie G. · Reviewed ما يقرب من سنتين ago

sefi r. · Reviewed حوالي سنتان ago

Julie L. · Reviewed حوالي سنتان ago

Julie L. · Reviewed حوالي سنتان 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 حوالي سنتان ago

Jonathan C. · Reviewed حوالي سنتان ago

Marcelo G. · Reviewed حوالي سنتان ago

yugender b. · Reviewed حوالي سنتان ago

Joyce W. · Reviewed حوالي سنتان ago

Namita R. · Reviewed حوالي سنتان ago

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

Hila C. · Reviewed حوالي سنتان ago

Saar S. · Reviewed حوالي سنتان ago

Diego R. · Reviewed حوالي سنتان ago

Carlos Andres F. · Reviewed حوالي سنتان ago

Carla C. · Reviewed حوالي سنتان ago

Sindy G. · Reviewed حوالي سنتان ago

Ana Paula G. · Reviewed حوالي سنتان ago

Ricardo T. · Reviewed حوالي سنتان ago

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

Lautaro C. · Reviewed حوالي سنتان ago

Paloma M. · Reviewed حوالي سنتان ago

Paloma M. · Reviewed حوالي سنتان ago