字符串截取 https://blog.csdn.net/yin767833376/article/details/52126664 统计null的个数 https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators 使用sum统计判断返回boolean值,默认true会隐式转换为int的1 1 2