As per you desired result, this isn't that much hard to write the query for this.

-------- for 2014-2015

select ID

, STATUS

, START_DATE

, END_DATE

, date_year

from remp_year

Where date_year = '2014-2015'

and STATUS = 'Active'

order by START_DATE

-------- for 2015-2016

select ID

, STATUS

, START_DATE

, END_DATE

, date_year

from remp_year

Where date_year = '2015-2016'

and STATUS = 'Active'

order by START_DATE

you just need to put filter on your status column.