-- 某段时间内的问答SELECT answered_at, instrument, company_name, question, answerFROM social_004_sse_qaWHERE answered_at >= '2026-11-03' AND answered_at < '2026-11-04'ORDER BY answered_at DESC
sql
-- 每日各公司的回复数SELECT CAST(answered_at AS DATE) AS day, instrument, count(*) AS answersFROM social_004_sse_qaWHERE answered_at >= '2026-11-01'GROUP BY day, instrumentORDER BY day DESC, answers DESC