尚硅谷 Vibe Coding实战教程

1个小菜鸡

6666

一枪断肠人

666

groker1

666666666

qss

666

卑微仔

1111111

tursch

感谢分享

fujun

666666

q1219331697

11

zhaojinfei

感谢分享

it00544

SELECT COUNT(1) as row_count, MAX(LENGTH(`flag`)) as maxlen_flag, MIN(LENGTH(`flag`)) as minlen_flag, ROUND(AVG(COALESCE(LENGTH(`flag`), 0)), 4) as avglen_flag, COUNTIF(LOWER(`flag`) = 'null') as nullstr_flag, SUM(CASE WHEN `flag` IS NULL THEN 1 ELSE 0 END) as null_flag, MAX(LENGTH(`payment_date`)) as maxlen_payment_date, MIN(LENGTH(`payment_date`)) as minlen_payment_date, ROUND(AVG(COALESCE(LENGTH(`payment_date`), 0)), 4) as avglen_payment_date, COUNTIF(LOWER(`payment_date`) = 'null') as nullstr_payment_date, SUM(CASE WHEN `payment_date` IS NULL THEN 1 ELSE 0 END) as null_payment_date, MAX(LENGTH(`payment_time`)) as maxlen_payment_time, MIN(LENGTH(`payment_time`)) as minlen_payment_time, ROUND(AVG(COALESCE(LENGTH(`payment_time`), 0)), 4) as avglen_payment_time, COUNTIF(LOWER(`payment_time`) = 'null') as nullstr_payment_time, SUM(CASE WHEN `payment_time` IS NULL THEN 1 ELSE 0 END) as null_payment_time, ROUND(CAST(SUM(CAST(`bill_id` AS FLOAT64)) AS FLOAT64), 4) as sum_bill_id, ROUND(CAST(AVG(CAST(`bill_id` AS FLOAT64)) AS FLOAT64), 4) as avg_bill_id, SUM(CASE WHEN `bill_id` IS NULL THEN 1 ELSE 0 END) as null_bill_id, MAX(LENGTH(`receipt_num`)) as maxlen_receipt_num, MIN(LENGTH(`receipt_num`)) as minlen_receipt_num, ROUND(AVG(COALESCE(LENGTH(`receipt_num`), 0)), 4) as avglen_receipt_num, COUNTIF(LOWER(`receipt_num`) = 'null') as nullstr_receipt_num, SUM(CASE WHEN `receipt_num` IS NULL THEN 1 ELSE 0 END) as null_receipt_num, MAX(LENGTH(`partner_sn`)) as maxlen_partner_sn, MIN(LENGTH(`partner_sn`)) as minlen_partner_sn, ROUND(AVG(COALESCE(LENGTH(`partner_sn`), 0)), 4) as avglen_partner_sn, COUNTIF(LOWER(`partner_sn`) = 'null') as nullstr_partner_sn, SUM(CASE WHEN `partner_sn` IS NULL THEN 1 ELSE 0 END) as null_partner_sn, MAX(LENGTH(`mdn`)) as maxlen_mdn, MIN(LENGTH(`mdn`)) as minlen_mdn, ROUND(AVG(COALESCE(LENGTH(`mdn`), 0)), 4) as avglen_mdn, COUNTIF(LOWER(`mdn`) = 'null') as nullstr_mdn, SUM(CASE WHEN `mdn` IS NULL THEN 1 ELSE 0 END) as null_mdn, MAX(LENGTH(`trans_type`)) as maxlen_trans_type, MIN(LENGTH(`trans_type`)) as minlen_trans_type, ROUND(AVG(COALESCE(LENGTH(`trans_type`), 0)), 4) as avglen_trans_type, COUNTIF(LOWER(`trans_type`) = 'null') as nullstr_trans_type, SUM(CASE WHEN `trans_type` IS NULL THEN 1 ELSE 0 END) as null_trans_type, MAX(LENGTH(`alt_mdn`)) as maxlen_alt_mdn, MIN(LENGTH(`alt_mdn`)) as minlen_alt_mdn, ROUND(AVG(COALESCE(LENGTH(`alt_mdn`), 0)), 4) as avglen_alt_mdn, COUNTIF(LOWER(`alt_mdn`) = 'null') as nullstr_alt_mdn, SUM(CASE WHEN `alt_mdn` IS NULL THEN 1 ELSE 0 END) as null_alt_mdn, MAX(LENGTH(`acct_nbr`)) as maxlen_acct_nbr, MIN(LENGTH(`acct_nbr`)) as minlen_acct_nbr, ROUND(AVG(COALESCE(LENGTH(`acct_nbr`), 0)), 4) as avglen_acct_nbr, COUNTIF(LOWER(`acct_nbr`) = 'null') as nullstr_acct_nbr, SUM(CASE WHEN `acct_nbr` IS NULL THEN 1 ELSE 0 END) as null_acct_nbr, MAX(LENGTH(`name`)) as maxlen_name, MIN(LENGTH(`name`)) as minlen_name, ROUND(AVG(COALESCE(LENGTH(`name`), 0)), 4) as avglen_name, COUNTIF(LOWER(`name`) = 'null') as nullstr_name, SUM(CASE WHEN `name` IS NULL THEN 1 ELSE 0 END) as null_name, MAX(LENGTH(`martketing_category`)) as maxlen_martketing_category, MIN(LENGTH(`martketing_category`)) as minlen_martketing_category, ROUND(AVG(COALESCE(LENGTH(`martketing_category`), 0)), 4) as avglen_martketing_category, COUNTIF(LOWER(`martketing_category`) = 'null') as nullstr_martketing_category, SUM(CASE WHEN `martketing_category` IS NULL THEN 1 ELSE 0 END) as null_martketing_category, MAX(LENGTH(`pre_postpaid`)) as maxlen_pre_postpaid, MIN(LENGTH(`pre_postpaid`)) as minlen_pre_postpaid, ROUND(AVG(COALESCE(LENGTH(`pre_postpaid`), 0)), 4) as avglen_pre_postpaid, COUNTIF(LOWER(`pre_postpaid`) = 'null') as nullstr_pre_postpaid, SUM(CASE WHEN `pre_postpaid` IS NULL THEN 1 ELSE 0 END) as null_pre_postpaid, MAX(LENGTH(`payment_method`)) as maxlen_payment_method, MIN(LENGTH(`payment_method`)) as minlen_payment_method, ROUND(AVG(COALESCE(LENGTH(`payment_method`), 0)), 4) as avglen_payment_method, COUNTIF(LOWER(`payment_method`) = 'null') as nullstr_payment_method, SUM(CASE WHEN `payment_method` IS NULL THEN 1 ELSE 0 END) as null_payment_method, MAX(LENGTH(`payment_channel_group`)) as maxlen_payment_channel_group, MIN(LENGTH(`payment_channel_group`)) as minlen_payment_channel_group, ROUND(AVG(COALESCE(LENGTH(`payment_channel_group`), 0)), 4) as avglen_payment_channel_group, COUNTIF(LOWER(`payment_channel_group`) = 'null') as nullstr_payment_channel_group, SUM(CASE WHEN `payment_channel_group` IS NULL THEN 1 ELSE 0 END) as null_payment_channel_group, MAX(LENGTH(`payment_channel_name`)) as maxlen_payment_channel_name, MIN(LENGTH(`payment_channel_name`)) as minlen_payment_channel_name, ROUND(AVG(COALESCE(LENGTH(`payment_channel_name`), 0)), 4) as avglen_payment_channel_name, COUNTIF(LOWER(`payment_channel_name`) = 'null') as nullstr_payment_channel_name, SUM(CASE WHEN `payment_channel_name` IS NULL THEN 1 ELSE 0 END) as null_payment_channel_name, MAX(LENGTH(`bank_code`)) as maxlen_bank_code, MIN(LENGTH(`bank_code`)) as minlen_bank_code, ROUND(AVG(COALESCE(LENGTH(`bank_code`), 0)), 4) as avglen_bank_code, COUNTIF(LOWER(`bank_code`) = 'null') as nullstr_bank_code, SUM(CASE WHEN `bank_code` IS NULL THEN 1 ELSE 0 END) as null_bank_code, MAX(LENGTH(`rec_ref_attr`)) as maxlen_rec_ref_attr, MIN(LENGTH(`rec_ref_attr`)) as minlen_rec_ref_attr, ROUND(AVG(COALESCE(LENGTH(`rec_ref_attr`), 0)), 4) as avglen_rec_ref_attr, COUNTIF(LOWER(`rec_ref_attr`) = 'null') as nullstr_rec_ref_attr, SUM(CASE WHEN `rec_ref_attr` IS NULL THEN 1 ELSE 0 END) as null_rec_ref_attr, ROUND(CAST(SUM(CAST(`amount` AS FLOAT64)) AS FLOAT64), 4) as sum_amount, ROUND(CAST(AVG(CAST(`amount` AS FLOAT64)) AS FLOAT64), 4) as avg_amount, SUM(CASE WHEN `amount` IS NULL THEN 1 ELSE 0 END) as null_amount, ROUND(CAST(SUM(CAST(`prd_id` AS FLOAT64)) AS FLOAT64), 4) as sum_prd_id, ROUND(CAST(AVG(CAST(`prd_id` AS FLOAT64)) AS FLOAT64), 4) as avg_prd_id, SUM(CASE WHEN `prd_id` IS NULL THEN 1 ELSE 0 END) as null_prd_id, MAX(LENGTH(`party_code`)) as maxlen_party_code, MIN(LENGTH(`party_code`)) as minlen_party_code, ROUND(AVG(COALESCE(LENGTH(`party_code`), 0)), 4) as avglen_party_code, COUNTIF(LOWER(`party_code`) = 'null') as nullstr_party_code, SUM(CASE WHEN `party_code` IS NULL THEN 1 ELSE 0 END) as null_party_code, MAX(LENGTH(`approval_code`)) as maxlen_approval_code, MIN(LENGTH(`approval_code`)) as minlen_approval_code, ROUND(AVG(COALESCE(LENGTH(`approval_code`), 0)), 4) as avglen_approval_code, COUNTIF(LOWER(`approval_code`) = 'null') as nullstr_approval_code, SUM(CASE WHEN `approval_code` IS NULL THEN 1 ELSE 0 END) as null_approval_code, MAX(LENGTH(`fix_denom`)) as maxlen_fix_denom, MIN(LENGTH(`fix_denom`)) as minlen_fix_denom, ROUND(AVG(COALESCE(LENGTH(`fix_denom`), 0)), 4) as avglen_fix_denom, COUNTIF(LOWER(`fix_denom`) = 'null') as nullstr_fix_denom, SUM(CASE WHEN `fix_denom` IS NULL THEN 1 ELSE 0 END) as null_fix_denom, ROUND(CAST(SUM(CAST(`promotion_amount` AS FLOAT64)) AS FLOAT64), 4) as sum_promotion_amount, ROUND(CAST(AVG(CAST(`promotion_amount` AS FLOAT64)) AS FLOAT64), 4) as avg_promotion_amount, SUM(CASE WHEN `promotion_amount` IS NULL THEN 1 ELSE 0 END) as null_promotion_amount, ROUND(CAST(SUM(CAST(`net_amount` AS FLOAT64)) AS FLOAT64), 4) as sum_net_amount, ROUND(CAST(AVG(CAST(`net_amount` AS FLOAT64)) AS FLOAT64), 4) as avg_net_amount, SUM(CASE WHEN `net_amount` IS NULL THEN 1 ELSE 0 END) as null_net_amount, ROUND(CAST(SUM(CAST(`paggr_order_his_id` AS FLOAT64)) AS FLOAT64), 4) as sum_paggr_order_his_id, ROUND(CAST(AVG(CAST(`paggr_order_his_id` AS FLOAT64)) AS FLOAT64), 4) as avg_paggr_order_his_id, SUM(CASE WHEN `paggr_order_his_id` IS NULL THEN 1 ELSE 0 END) as null_paggr_order_his_id, MAX(LENGTH(`paggr_method`)) as maxlen_paggr_method, MIN(LENGTH(`paggr_method`)) as minlen_paggr_method, ROUND(AVG(COALESCE(LENGTH(`paggr_method`), 0)), 4) as avglen_paggr_method, COUNTIF(LOWER(`paggr_method`) = 'null') as nullstr_paggr_method, SUM(CASE WHEN `paggr_method` IS NULL THEN 1 ELSE 0 END) as null_paggr_method, ROUND(CAST(SUM(CAST(`paggr_partner_id` AS FLOAT64)) AS FLOAT64), 4) as sum_paggr_partner_id, ROUND(CAST(AVG(CAST(`paggr_partner_id` AS FLOAT64)) AS FLOAT64), 4) as avg_paggr_partner_id, SUM(CASE WHEN `paggr_partner_id` IS NULL THEN 1 ELSE 0 END) as null_paggr_partner_id, MAX(LENGTH(`purch_no`)) as maxlen_purch_no, MIN(LENGTH(`purch_no`)) as minlen_purch_no, ROUND(AVG(COALESCE(LENGTH(`purch_no`), 0)), 4) as avglen_purch_no, COUNTIF(LOWER(`purch_no`) = 'null') as nullstr_purch_no, SUM(CASE WHEN `purch_no` IS NULL THEN 1 ELSE 0 END) as null_purch_no, MAX(LENGTH(`purch_channel`)) as maxlen_purch_channel, MIN(LENGTH(`purch_channel`)) as minlen_purch_channel, ROUND(AVG(COALESCE(LENGTH(`purch_channel`), 0)), 4) as avglen_purch_channel, COUNTIF(LOWER(`purch_channel`) = 'null') as nullstr_purch_channel, SUM(CASE WHEN `purch_channel` IS NULL THEN 1 ELSE 0 END) as null_purch_channel, MAX(LENGTH(`matcode`)) as maxlen_matcode, MIN(LENGTH(`matcode`)) as minlen_matcode, ROUND(AVG(COALESCE(LENGTH(`matcode`), 0)), 4) as avglen_matcode, COUNTIF(LOWER(`matcode`) = 'null') as nullstr_matcode, SUM(CASE WHEN `matcode` IS NULL THEN 1 ELSE 0 END) as null_matcode, MAX(LENGTH(`sap_billing_no`)) as maxlen_sap_billing_no, MIN(LENGTH(`sap_billing_no`)) as minlen_sap_billing_no, ROUND(AVG(COALESCE(LENGTH(`sap_billing_no`), 0)), 4) as avglen_sap_billing_no, COUNTIF(LOWER(`sap_billing_no`) = 'null') as nullstr_sap_billing_no, SUM(CASE WHEN `sap_billing_no` IS NULL THEN 1 ELSE 0 END) as null_sap_billing_no, MAX(LENGTH(`sap_bill_log`)) as maxlen_sap_bill_log, MIN(LENGTH(`sap_bill_log`)) as minlen_sap_bill_log, ROUND(AVG(COALESCE(LENGTH(`sap_bill_log`), 0)), 4) as avglen_sap_bill_log, COUNTIF(LOWER(`sap_bill_log`) = 'null') as nullstr_sap_bill_log, SUM(CASE WHEN `sap_bill_log` IS NULL THEN 1 ELSE 0 END) as null_sap_bill_log, MAX(LENGTH(`sap_so_number`)) as maxlen_sap_so_number, MIN(LENGTH(`sap_so_number`)) as minlen_sap_so_number, ROUND(AVG(COALESCE(LENGTH(`sap_so_number`), 0)), 4) as avglen_sap_so_number, COUNTIF(LOWER(`sap_so_number`) = 'null') as nullstr_sap_so_number, SUM(CASE WHEN `sap_so_number` IS NULL THEN 1 ELSE 0 END) as null_sap_so_number, MAX(LENGTH(`sap_so_log`)) as maxlen_sap_so_log, MIN(LENGTH(`sap_so_log`)) as minlen_sap_so_log, ROUND(AVG(COALESCE(LENGTH(`sap_so_log`), 0)), 4) as avglen_sap_so_log, COUNTIF(LOWER(`sap_so_log`) = 'null') as nullstr_sap_so_log, SUM(CASE WHEN `sap_so_log` IS NULL THEN 1 ELSE 0 END) as null_sap_so_log, MAX(LENGTH(`sap_payer`)) as maxlen_sap_payer, MIN(LENGTH(`sap_payer`)) as minlen_sap_payer, ROUND(AVG(COALESCE(LENGTH(`sap_payer`), 0)), 4) as avglen_sap_payer, COUNTIF(LOWER(`sap_payer`) = 'null') as nullstr_sap_payer, SUM(CASE WHEN `sap_payer` IS NULL THEN 1 ELSE 0 END) as null_sap_payer, MAX(LENGTH(`sap_promotion`)) as maxlen_sap_promotion, MIN(LENGTH(`sap_promotion`)) as minlen_sap_promotion, ROUND(AVG(COALESCE(LENGTH(`sap_promotion`), 0)), 4) as avglen_sap_promotion, COUNTIF(LOWER(`sap_promotion`) = 'null') as nullstr_sap_promotion, SUM(CASE WHEN `sap_promotion` IS NULL THEN 1 ELSE 0 END) as null_sap_promotion, ROUND(CAST(SUM(CAST(`price_plan_id` AS FLOAT64)) AS FLOAT64), 4) as sum_price_plan_id, ROUND(CAST(AVG(CAST(`price_plan_id` AS FLOAT64)) AS FLOAT64), 4) as avg_price_plan_id, SUM(CASE WHEN `price_plan_id` IS NULL THEN 1 ELSE 0 END) as null_price_plan_id, SUM(CASE WHEN `is_ipp` IS NULL THEN 1 ELSE 0 END) as null_is_ipp, FORMAT_TIMESTAMP('%Y-%m-%d %H:%M:%S', TIMESTAMP_SECONDS(CAST(AVG(IF(EXTRACT(YEAR FROM CAST(`partition_date` AS TIMESTAMP)) BETWEEN 1900 AND 2200, UNIX_SECONDS(CAST(`partition_date` AS TIMESTAMP)), NULL)) AS INT64))) as avgts_partition_date, SUM(CASE WHEN `partition_date` IS NULL THEN 1 ELSE 0 END) as null_partition_date, COUNTIF(`partition_date` IS NOT NULL AND (EXTRACT(YEAR FROM CAST(`partition_date` AS TIMESTAMP)) < 1900 OR EXTRACT(YEAR FROM CAST(`partition_date` AS TIMESTAMP)) > 2200)) as sentinel_partition_date, ROUND(CAST(SUM(CAST(`service_fee` AS FLOAT64)) AS FLOAT64), 4) as sum_service_fee, ROUND(CAST(AVG(CAST(`service_fee` AS FLOAT64)) AS FLOAT64), 4) as avg_service_fee, SUM(CASE WHEN `service_fee` IS NULL THEN 1 ELSE 0 END) as null_service_fee FROM `smartfren-analytic-prd.rpt_cc.rpt_rep_cognos_api_all` WHERE `partition_date` = DATE '2026-07-31'