SQL predicates, also referred to as conditional expressions, specify a condition of a row or group that has one of…