subtracting in sql when condition is true in query code example

Example: minus in sql

The SQL MINUS operator is used to return 
all rows in the first SELECT statement
that are not returned by the second SELECT statement.
Each SELECT statement will define a dataset. 
]The MINUS operator will retrieve all records
from the first dataset and then remove from
the results all records from the second dataset.