How do you create a view in SQL?

You create a view in SQL using the CREATE VIEW statement followed by the SELECT statement.

In SQL, a view is a virtual table based on the result-set of an SQL statement. It contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database. To create a view, you use the CREATE VIEW statement, which has the following syntax:

```
CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;
```

In this syntax, `view_name` is the name of the view that you want to create. `column1, column2, ...` are the columns that you want in your view. `table_name` is the name of the table from which you want to create the view. `WHERE condition` is an optional clause that you can use to filter rows that you want in the view.

For example, if you have a table named `Orders` and you want to create a view that contains only the `OrderID` and `CustomerID` for all orders that have a `Quantity` greater than 10, you would use the following SQL statement:

```
CREATE VIEW LargeOrders AS
SELECT OrderID, CustomerID
FROM Orders
WHERE Quantity > 10;
```

Once you have created a view, you can query it in the same way as you would a real table. For example, to select all records in the `LargeOrders` view, you would use the following SQL statement:

```
SELECT *
FROM LargeOrders;
```

Remember, a view is not a physical table but a virtual table created by a query joining one or more tables. Therefore, any changes in the underlying tables can be reflected in the view. However, views do not occupy physical space in your database. They are a great way to encapsulate your queries, especially complex ones, and can help to simplify SQL operations.