SQL query in order to get my desired output

I have an input table like this:

SQL QUERY FOR achieveing OUTPUT

I have an input table like below