SELECT * FROM Tab WHERE CreateTime>=(SELECT MIN(a) FROM (SELECT strftime('%Y-%m-%d',CreateTime) as a FROM Tab group by strftime('%Y-%m-%d',CreateTime) ORDER BY strftime('%Y-%m-%d',CreateTime) DESC LIMIT 7)) AND ProjectId = 'xxxx';
SELECT * FROM Tab WHERE CreateTime>=(SELECT MIN(a) FROM (SELECT strftime('%Y-%m-%d',CreateTime) as a FROM Tab group by strftime('%Y-%m-%d',CreateTime) ORDER BY strftime('%Y-%m-%d',CreateTime) DESC LIMIT 7)) AND ProjectId = 'xxxx';