What is a SQL VIEW? When use it?

SQL VIEW

CREATE VIEW active_students AS
SELECT * FROM students WHERE status = 'ACTIVE';

Virtual table—saved query. Simplifies reporting; not always materialized.