select Tnameselect name from T_SYS_ORGANIZATION where id = tPARENT_ID dwnameA001A001001A001A001006y1y2y3y4SELECT TITLE FROM T_SYS_CODE_VALUE WHERE CODE_ID = 02b14118-3cee-443c-a206-3a0b3f125612 AND VA

The query selects the name of the T table, the name of the parent organization (retrieved from the T_SYS_ORGANIZATION table), A001001, A001006, y1, y2, y3, y4, and the corresponding titles for each y value from the T_SYS_CODE_VALUE table.

It joins the A001 table with the T_SYS_ORGANIZATION table and four subqueries, each joining the A001, A103, and T_SYS_ORGANIZATION tables to retrieve the y and r values for different years.

The WHERE clause filters the results by the code from the T_SYS_ORGANIZATION table and checks for specific conditions for the y and r values. Only those records that satisfy the specified conditions will be displayed