SQL查询结果为空补充默认值ISNULL

ISNULL用法：
多表查询统计结果时，部分字段内容为空，可以自动补充默认值

select ISNULL(S.[state], 0),ISNULL(S.[insertUserId], 4869)   from [train_video_data] V 
LEFT JOIN [train_video_study_data] S ON V.[courseId] = S.[courseId] AND V.[videoId] = S.[videoId]
where V.[courseId] = 636235546473141211 AND V.[state] = 1