课程: Coding Exercises: SQL Data Science

今天就学习课程吧！

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

Using COALESCE to replace null values

Using COALESCE to replace null values - SQL教程

课程: Coding Exercises: SQL Data Science

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

Using COALESCE to replace null values

“

(upbeat music) - Hayley has run into another error. She is new to the world of sequel and she is seeking help from you, Again. This time, she is working with the Olympic games data, and she thinks that there are some null values in the data, which is causing the error. She needs help with two tasks. First, to figure out if there are any null values in the data and if there are null values, how should she handle those? So in this challenge, you have to write two queries. The first one, to display the rules, where you have null values, which will serve as a check for null values and the second one to impure or fill those missing values with NA strings. So here are some details to structure that query. You have to check for null values in the medal column of the games table. Secondly, you can use 'IS NULL' to check for null values in the medal column. So this will come in the where clause and you can use the coalesce…

内容