帮我创建一个数据库，以下的所有要求用sq|语句实现并且要尽量简单1.至少包含5个表，每个表中至少有10条数据，至少2个表有外键.2.使用模式匹配查询，使用top查询，in查询，降序查询，使用count集合函数查询，分组统计查询，使用连接条件的多表查询，比较运算符的子查询，使用in的子查询.3.创建视图并使用4.创建索引5.创建唯一性约束，检查约束，默认值约束，外键约束。6.创建一个存储过程并使用7.在某个表中创建一个插入和更新的dml触发器

好的，以下是创建一个符合你要求的数据库的 SQL 语句：

-- 创建数据库
CREATE DATABASE mydatabase;

-- 切换到 mydatabase 数据库
USE mydatabase;

-- 创建表1
CREATE TABLE table1 (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    age INT,
    email VARCHAR(50)
);

-- 创建表2
CREATE TABLE table2 (
    id INT PRIMARY KEY,
    table1_id INT,
    address VARCHAR(100),
    FOREIGN KEY (table1_id) REFERENCES table1(id)
);

-- 创建表3
CREATE TABLE table3 (
    id INT PRIMARY KEY,
    table1_id INT,
    salary INT,
    FOREIGN KEY (table1_id) REFERENCES table1(id)
);

-- 创建表4
CREATE TABLE table4 (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    type VARCHAR(50),
    price INT
);

-- 创建表5
CREATE TABLE table5 (
    id INT PRIMARY KEY,
    table4_id INT,
    quantity INT,
    FOREIGN KEY (table4_id) REFERENCES table4(id)
);

-- 插入数据
INSERT INTO table1 VALUES (1, 'John', 20, 'john@test.com');
INSERT INTO table1 VALUES (2, 'Mary', 25, 'mary@test.com');
INSERT INTO table1 VALUES (3, 'Bob', 30, 'bob@test.com');
INSERT INTO table1 VALUES (4, 'Alice', 35, 'alice@test.com');
INSERT INTO table1 VALUES (5, 'Tom', 40, 'tom@test.com');
INSERT INTO table1 VALUES (6, 'Lucy', 45, 'lucy@test.com');
INSERT INTO table1 VALUES (7, 'David', 50, 'david@test.com');
INSERT INTO table1 VALUES (8, 'Sarah', 55, 'sarah@test.com');
INSERT INTO table1 VALUES (9, 'Peter', 60, 'peter@test.com');
INSERT INTO table1 VALUES (10, 'Kate', 65, 'kate@test.com');

INSERT INTO table2 VALUES (1, 1, '123 Main St');
INSERT INTO table2 VALUES (2, 2, '456 Elm St');
INSERT INTO table2 VALUES (3, 3, '789 Oak St');
INSERT INTO table2 VALUES (4, 4, '321 Maple St');
INSERT INTO table2 VALUES (5, 5, '654 Pine St');
INSERT INTO table2 VALUES (6, 6, '987 Cedar St');
INSERT INTO table2 VALUES (7, 7, '246 Walnut St');
INSERT INTO table2 VALUES (8, 8, '135 Birch St');
INSERT INTO table2 VALUES (9, 9, '864 Cherry St');
INSERT INTO table2 VALUES (10, 10, '579 Orange St');

INSERT INTO table3 VALUES (1, 1, 2000);
INSERT INTO table3 VALUES (2, 2, 3000);
INSERT INTO table3 VALUES (3, 3, 4000);
INSERT INTO table3 VALUES (4, 4, 5000);
INSERT INTO table3 VALUES (5, 5, 6000);
INSERT INTO table3 VALUES (6, 6, 7000);
INSERT INTO table3 VALUES (7, 7, 8000);
INSERT INTO table3 VALUES (8, 8, 9000);
INSERT INTO table3 VALUES (9, 9, 10000);
INSERT INTO table3 VALUES (10, 10, 11000);

INSERT INTO table4 VALUES (1, 'iPhone', 'Mobile', 1000);
INSERT INTO table4 VALUES (2, 'Samsung', 'Mobile', 900);
INSERT INTO table4 VALUES (3, 'HP', 'Laptop', 1200);
INSERT INTO table4 VALUES (4, 'Dell', 'Laptop', 1100);
INSERT INTO table4 VALUES (5, 'Sony', 'TV', 1500);
INSERT INTO table4 VALUES (6, 'LG', 'TV', 1400);
INSERT INTO table4 VALUES (7, 'Canon', 'Camera', 800);
INSERT INTO table4 VALUES (8, 'Nikon', 'Camera', 900);
INSERT INTO table4 VALUES (9, 'Apple', 'Tablet', 1100);
INSERT INTO table4 VALUES (10, 'Microsoft', 'Tablet', 1000);

INSERT INTO table5 VALUES (1, 1, 2);
INSERT INTO table5 VALUES (2, 2, 3);
INSERT INTO table5 VALUES (3, 3, 4);
INSERT INTO table5 VALUES (4, 4, 5);
INSERT INTO table5 VALUES (5, 5, 6);
INSERT INTO table5 VALUES (6, 6, 7);
INSERT INTO table5 VALUES (7, 7, 8);
INSERT INTO table5 VALUES (8, 8, 9);
INSERT INTO table5 VALUES (9, 9, 10);
INSERT INTO table5 VALUES (10, 10, 11);

-- 使用模式匹配查询
SELECT * FROM table1 WHERE name LIKE 'J%';

-- 使用 top 查询
SELECT TOP 3 * FROM table2;

-- 使用 in 查询
SELECT * FROM table4 WHERE type IN ('Mobile', 'Laptop');

-- 降序查询
SELECT * FROM table3 ORDER BY salary DESC;

-- 使用 count 集合函数查询
SELECT COUNT(*) FROM table1;

-- 分组统计查询
SELECT table1_id, COUNT(*) FROM table2 GROUP BY table1_id;

-- 使用连接条件的多表查询
SELECT table1.name, table2.address FROM table1 INNER JOIN table2 ON table1.id = table2.table1_id;

-- 比较运算符的子查询
SELECT * FROM table1 WHERE age > (SELECT AVG(age) FROM table1);

-- 使用 in 的子查询
SELECT name FROM table1 WHERE id IN (SELECT table1_id FROM table2 WHERE address LIKE '%St');

-- 创建视图
CREATE VIEW view1 AS SELECT id, name FROM table1 WHERE age > 30;

-- 创建索引
CREATE INDEX idx_table3_salary ON table3 (salary);

-- 创建唯一性约束
ALTER TABLE table1 ADD CONSTRAINT uc_table1_email UNIQUE (email);

-- 检查约束
ALTER TABLE table4 ADD CONSTRAINT ck_table4_price CHECK (price > 0);

-- 默认值约束
ALTER TABLE table5 ADD CONSTRAINT df_table5_quantity DEFAULT 0 FOR quantity;

-- 创建外键约束
ALTER TABLE table3 ADD CONSTRAINT fk_table3_table1 FOREIGN KEY (table1_id) REFERENCES table1(id);

-- 创建存储过程
CREATE PROCEDURE sp_table1_insert (
    @id INT,
    @name VARCHAR(50),
    @age INT,
    @email VARCHAR(50)
) AS
BEGIN
    INSERT INTO table1 VALUES (@id, @name, @age, @email);
END;

-- 使用存储过程
EXEC sp_table1_insert 11, 'Jack', 70, 'jack@test.com';

-- 创建触发器
CREATE TRIGGER tr_table5_insert_update
ON table5
AFTER INSERT, UPDATE
AS
BEGIN
    UPDATE table4
    SET price = price + i.quantity * 100
    FROM table4
    INNER JOIN inserted i ON table4.id = i.table4_id;
END;