Create a View of Active Customers

Create a view named ActiveCustomers that exposes the id and name of customers whose status is 'active'. Then select all rows from the view ordered by id.

Table schema

Customers(id INT PRIMARY KEY, name VARCHAR(50), status VARCHAR(20))

Sample data

id | name | status
1 | Aman | active
2 | Riya | inactive
3 | Karan | active