-- 查看最近7天访问日志
select 
  * 
from 
  (
    SELECT 
      UserAgent, 
      count(UserAgent) as UACount 
    FROM 
      "AccessRecord" 
    where 
      StartTime >= datetime(
        'now', 'start of day', '-7 day', 'weekday 1'
      ) 
      AND StartTime < datetime(
        'now', 'start of day', '+0 day', 'weekday 1'
      ) 
    group by 
      UserAgent
  ) 
order by 
  UACount desc 
limit 
  100