So, you want to always take the first row, if you order by year ascending? Why don't you just do that?

select
...
order by year asc
limit 1
[download]

or, depending on your brand of database

select top 1
...
order by year asc
[download]