查询包含oracle db中多个字段的年份

i am trying to write a query in oracle db that helps me to select something that contains all 3 data, let me show an example Say I have a table i am trying to write a query in oracle db that