last month: where time > now() - interval '1 month'