SELECT EXAMCODE,EXAMNAME,INSTCODE,INSTNAME,GOVTPVT,INSTTYPE,Sum(SEATS) AS TotSeats, SUM(Reg) AS TotReg, Sum(IsAdmit) AS TotAdmit,Sum(SEATS)-Sum(IsAdmit) AS TotVacant FROM( select me.examlist_code as EXAMCODE,me.examlist_name AS EXAMNAME, a.INST_CODE AS INSTCODE, i.INST_NAME AS INSTNAME, i.GOVT_PVT AS GOVTPVT, i.INST_TYPE AS INSTTYPE, a.SEATS AS SEATS,0 AS Reg,0 AS IsAdmit from institutedetail AS i INNER JOIN admission_intake_capacity AS a on a.INST_CODE = i.INST_CODE INNER JOIN master_examlist me ON me.examlist_code=a.EXAM_CODE where a.INST_CODE='704' and a.EXAM_CODE='N041' UNION select me.examlist_code as EXAMCODE,me.examlist_name AS EXAMNAME,a.INST_CODE AS INSTCODE, i.INST_NAME AS INSTNAME, i.GOVT_PVT AS GOVTPVT, i.INST_TYPE AS INSTTYPE, 0 AS SEATS,SUM(1) AS Reg,0 AS IsAdmit from institutedetail AS i INNER JOIN selected_inst_subject AS a on a.INST_CODE = i.INST_CODE INNER JOIN master_examlist me ON me.examlist_code=a.EXAM_CODE where a.INST_CODE='704' and a.EXAM_CODE='N041' GROUP BY me.examlist_code,me.examlist_name,a.INST_CODE,i.INST_NAME, i.GOVT_PVT, i.INST_TYPE UNION select me.examlist_code as EXAMCODE,me.examlist_name AS EXAMNAME,a.INST_CODE AS INSTCODE, i.INST_NAME AS INSTNAME, i.GOVT_PVT AS GOVTPVT, i.INST_TYPE AS INSTTYPE, 0 AS SEATS,0 As Reg, SUM(1) AS IsAdmit from institutedetail AS i INNER JOIN selected_inst_subject AS a on a.INST_CODE = i.INST_CODE INNER JOIN master_examlist me ON me.examlist_code=a.EXAM_CODE where a.INST_CODE='704' and a.EXAM_CODE='N041' AND a.IS_ADMIT='1' GROUP BY me.examlist_code,me.examlist_name,a.INST_CODE,i.INST_NAME, i.GOVT_PVT, i.INST_TYPE ) AS X GROUP BY EXAMCODE,EXAMNAME,INSTCODE,INSTNAME,GOVTPVT,INSTTYPE Shaheed Nandkumar Patel Vishwavidyalaya, Raigarh (C.G.)
Shaheed Nandkumar Patel Vishwavidyalaya, Raigarh (C.G.)