select MIN(property_size) as min_area, MAX(property_size) as max_area, MIN(carpet_area) as min_carpet_area, MAX(carpet_area) as max_carpet_area, MIN(super_area) as min_super_area, MAX(super_area) as max_super_area, property_size_unit, carpet_area_unit, super_area_unit from project_oth_floor_plan_tbl as a1, project_bhk_tbl as b1 where a1.bhk_slno=b1.slno and a1.project_id=b1.project_id and a1.status IN ('N', 'Y') and b1.status IN ('N', 'Y') and a1.project_id='54512'
[TEP STOP]
