PSQL: extend a query to esclude certain data due a miss usage of the system

The extension should discard the record from the results when a specific condition is met so that data is not going by mistake further down in the system.

The task requires PoatgreSQL.