I have some data like above in a table. I want to make query as above
For example as there is not value in any of q1,q2,q3,q4 in 2019 then it will get data of 2018 as there is q3 value. if there was no value in q3 of 2018, then picked 2017.
is it possible ??????