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

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' );

来了，老弟

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

mysql的函数

https://www.runoob.com/mysql/mysql-functions.html

查询出的都是空数据