Non-farm payroll那麽不靠譜,怎麽大家還屁顛屁顛跟著跑呢?保不齊下個月又revise up了。
不知道搞這個數據有多難,我們拿W2的每月都繳SS稅,Medicare稅,財政部難道不會數數?DOGE把數據一匯總,數一數繳稅的social security number有幾個不就都有了?搞什麽勞什子抽樣,一尊說統統給我匯總上來!
SELECT COUNT(SSN) PAYROLL_COUNT FROM PAYROLL_TAX WHERE DATE BETWEEN '7/1/2025' AND '7/31/2025'
也許用了這個query, 每月付兩次三次四次的重複計數了
Revision:
SELECT COUNT(DISTINCT SSN) PAYROLL_COUNT FROM PAYROLL_TAX WHERE DATE BETWEEN '7/1/2025' AND '7/31/2025'