What is a database view? What are its advantages and when should you use one?

Sample answer preview

## What is a View? A view is a **virtual table** based on a SELECT query. It doesn't store data itself but provides a saved query that you can use like a table. ```sql -- Create a view CREATE VIEW active_users AS SELECT id, name, email, last_login FROM users WHERE status =…