Batch A has Ravi twice. Using EXCEPT ALL, return A's names minus B's names keeping duplicate counts.
3 rows with column student
student
Run your code to see the output here.