查询次数.txt 286 B

12345678910
  1. SELECT
  2. DATE_FORMAT(created_at,"%Y-%m-%d") as "使用日期",
  3. COUNT(1) as "使用次数"
  4. FROM
  5. `aigc_userpoints_logs`
  6. WHERE
  7. action_name = "客户端抠图"
  8. AND partner_company_id = 35662
  9. GROUP BY DATE_FORMAT(created_at,"%Y-%m-%d")
  10. ORDER BY DATE_FORMAT(created_at,"%Y-%m-%d") DESC