A view may not be updated directly if it contains:

Select one:

a$.$ derived columns and expressions in the SELECT clause.

b$.$ uses the GROUP BY or HAVING clause.

C$.$ the DISTINCT keyword.

d$.$ all of the above.