Hi Waghmare,
Refer below query.
SQL
CREATE TABLE #Exam (ID INT, ExamID INT ,Score INT, Passed INT, [Re-Attempted] INT)
INSERT INTO #Exam VALUES(1,2,25,1,0)
INSERT INTO #Exam VALUES(2,2,21,0,1)
INSERT INTO #Exam VALUES(3,2,24,1,0)
SELECT * FROM #Exam
CREATE TABLE #Result(Id INT, score INT, status INT)
INSERT INTO #Result
SELECT ID,Score,1 'status'
FROM #Exam
WHERE Score > 21
SELECT * FROM #Result
DROP TABLE #Exam
DROP TABLE #Result