I believe there seems to be an issue regarding the understanding of how EXCEPT
works in sql. The EXCEPT
operator returns rows from the first query that do not exist in the second query, not a subtraction of numerical values. (
If you are learning to use EXCEPT
you can refer to the following :https://www.geeksforgeeks.org/sql-except-clause/