#0585 · 方法
写 SQL 先对口径
写 SQL 之前,先用中文把口径写清:统计对象、时间范围和时区、去重方式、要排除的数据。等我确认口径再给 SQL,并附一条能抽查结果的验证查询。
Before writing any SQL, spell out the definition in plain words: what is counted, the time range and time zone, how duplicates are removed, what is excluded. Wait for me to confirm, then give the SQL plus one query I can use to spot-check the result.
小杜
已贴 1,040 张上墙共收到 0 个章