①用SQL语句完成数据增加、删除、修改、查询（单表查询、内连接、外连接、嵌套查询等）②用SQL语句完成视图的创建和使用视图查询数据

1. SQL语句完成数据增加、删除、修改、查询

单表查询：

查询表中所有数据：

SELECT * FROM table_name;

查询表中指定列的数据：

SELECT column1, column2, ... FROM table_name;

条件查询：

SELECT * FROM table_name WHERE condition;

数据插入：

INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

数据删除：

DELETE FROM table_name WHERE condition;

数据更新：

UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;

内连接：

SELECT * FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name;

左连接：

SELECT * FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;

右连接：

SELECT * FROM table1 RIGHT JOIN table2 ON table1.column_name = table2.column_name;

全连接：

SELECT * FROM table1 FULL OUTER JOIN table2 ON table1.column_name = table2.column_name;

嵌套查询：

SELECT * FROM table_name WHERE column_name IN (SELECT column_name FROM another_table_name WHERE condition);

2. SQL语句完成视图的创建和使用视图查询数据

创建视图：

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

使用视图：

SELECT * FROM view_name;