-- Synthetic reference DDL used to pad realistic repository shape. create table if not exists ref_3_01 (id varchar(36) primary key, detail varchar(255) not null, state varchar(32) not null); create ...

( NOTE : ABOVE ADVANTAGE IS WE CAN DISPLAY ONLY WHAT WE NEED THAT THINGS ONLY WE CAN ADD TO QUERY BUT ALL THE INNER QUERIES ARE EXECUTED BUT WE CAN RESTRICT WHAT DISPLAY IN OUTER SUBQUERY) ...