Facing an issue in sql query for execute query activity

hi,
i want to get dat from a table based on -
field_1,field_2,field_3,field_4 will be system dates data and field_5,field_6,field_7,field_8 will be previous days data, and date will be system date
. Pls check the below image.
image
how can i write the query to get this result?i am using ms sql.

What you want OutPut?

hi @copy_writes
Please check this below.

can any one help me to solve this