Asset Report Query

Hi,

I would like to generate a report for assets :
a) will expire in next 3 months
b) already expired last 1 year.

Appreciate if anyone can help me with the queries.

Thank you.
sabarina