Skip to content

Why this view refuses an UPDATE

```sql CREATE VIEW college_totals AS SELECT college_id, COUNT(*) AS student_count FROM students GROUP BY college_id;

UPDATE college_totals SET student_count = 500 WHERE college_id = 7; ```

The UPDATE is rejected. Why?