创建视图的SQL语句基本格式如下：
```sql
CREATE VIEW view_name AS SELECT column1, column2, ... FROM table_name WHERE condition；
```
其中：
`view_name` 是你给视图起的名称。
`SELECT column1, column2, ...` 是你希望从表中选择的列。
`FROM table_name` 是数据来源的表。
`WHERE condition` 是可选的，用于筛选出你希望显示的记录。
示例
单表视图
```sql
CREATE VIEW Student_View AS
SELECT Student_ID, Stu_Subject, Stu_Marks
FROM Student_Details
WHERE Stu_Marks > 85；
```
多表视图
```sql
CREATE VIEW Employee_View AS
SELECT e.name, e.department
FROM employees e；
```
带条件的视图
```sql
CREATE VIEW V_Pass_Students AS
SELECT student_name, subject, score
FROM student_scores
WHERE score >= 60；
```
复杂视图（多表联查）
```sql
CREATE VIEW V_Student_Detail AS
SELECT s.student_name, c.class_name, t.teacher_name, sc.score
FROM students s
JOIN classes c ON s.class_id = c.class_id
JOIN teachers t ON c.teacher_id = t.teacher_id
JOIN scores sc ON s.student_id = sc.student_id；
```
带计算的视图
```sql
CREATE VIEW Salary_Summary AS
SELECT department, AVG（salary） as avg_salary, MAX（salary） as max_salary
FROM employees
GROUP BY department；
```
通过这些示例，你可以看到如何根据不同的需求创建各种类型的视图。