query

select * from faculty_profile_publications where roll=308 and ptype='c' and pdate between '2021-04-01' and '2022-03-31' order by pdate desc;