From the course: Intermediate SQL for Data Scientists

Unlock this course with a free trial

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

Challenge: Prepare a data set for analysis

Challenge: Prepare a data set for analysis - SQL Tutorial

From the course: Intermediate SQL for Data Scientists

Start my 1-month free trial Buy for my team

Challenge: Prepare a data set for analysis

“

(upbeat instrumental music) - [Instructor] In this challenge, I'd like you to answer a few questions. First, what function could you use to reformat a number from having eight decimal places to having two decimal places? Also, what operator would you use to filter using regular expressions? And then finally, what function would you use to measure the difference in characters between two strings?

Contents