From the course: Advanced Analytics Engineering: Real-World Practice

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Solution: Time series data analysis with Python

Solution: Time series data analysis with Python

From the course: Advanced Analytics Engineering: Real-World Practice

Start my 1-month free trial Buy for my team

Solution: Time series data analysis with Python

“

(upbeat music) - [Instructor] Alright, here's the solution to our assessment. First, we needed to write a select statement selecting from our employee's table. We needed four columns first, the first name, last name, weekly pay, and department from that employee's table. Then we needed to write a dense rank function, which is partitioned by department, ordered by weekly pay descending, and we aliased it as department rank. Once we ordered by department and department rank, our output should look like what we have here on the left with 11 rows. If you got that right, great job. If you didn't, that's okay. Keep practicing, you'll get it.

Contents