求大神，帮我查询出第2，第3题的SQL语句

Question

Answer 1

SELECT *,(select incount from emp where indate = Date_format(CURRENT_DATE ( ),'%Y-%m'))as nowincount
FROM emp
where indate = Date_format( date_sub( CURRENT_DATE ( ), INTERVAL 1 YEAR ), '%Y-%m' );