Assume the following table- Degree (degcode, name, subject)

Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode degree code, name name of the degree (Eg. BSc.), subject subject of the course (Eg. DBMS), papcode paper code (Eg. CSE-3105)] Solve the following queries using SQL;

iii. All the degree codes which are there in the candidate table but not present in degree table in the order of degcode. iv. The name of all the candidates who have got less than 40 marks in exactly 2 subjects