Databricks · Databricks Data Analyst Associate
Aggregating, sorting, and filtering
Databricks Data Analyst Associate · Lesson 7 of 18 · 49:56
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the Databricks Certified Data Analyst Associate exam. In this lesson: aggregate functions (count, approx_count_distinct, percentiles), GROUP BY, WHERE and HAVING, ROLLUP and CUBE, summary statistics, ORDER BY with NULL values, and LIMIT for a top five. Includes three original practice questions.
Preview the topics
- A dashboard shows the number of different riders, from billions of ride events, and the query takes minutes. A margin of error of a few percent is fine. Which function should the query use?
- The analyst needs the stores whose average rental price is above $30. A query with WHERE avg(price) > 30 fails. What should the analyst write?
- The analyst writes ORDER BY revenue DESC LIMIT 5 to find the top five stores, but some new stores have a NULL revenue. With the default settings, where do those stores go?