课程: Coding Exercises: SQL Data Science

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Sorting with regular expressions

Sorting with regular expressions - SQL教程

课程: Coding Exercises: SQL Data Science

开始一个月试用 购买团队方案

Sorting with regular expressions

“

(upbeat chiptune music) (playful beeps) - [Harshit] Hayley is stuck at a string matching problem, and she wants to segregate that data for men's and women's games. She wants to study the game's stats for each gender separately, and she has reached out to you to help her filter out the data. (playful beeps) Now, the challenge is that you have to use regular expressions to match a substring from an event to extract data for all men's events. And same could be done for women's as well, so we are doing it only for the men's events. (sharp whooshing) Now, the table in question is the game stats table. Then you'll have to use REGEXP_MATCHES function to match a substring with the event string. So, event is the column that you will be using, and you have to extract the data for all the columns. So it's time for you to try your hand at writing this query. So pause the video, and once you are done, I'll show you how to use…

内容