题35: (1)首先通过子查询,将两个表拼接,过滤无用的数据; select 'succeeded' as 'state',success_date as 'dt' from Succeeded where success_date between ' 2019-01-01' and '2019-12-31 ' union select 'fail