SQL 语句示例：创建表格、插入数据、查询数据

当然可以！下面是根据提供的场景编写的一些基本的 SQL 语句示例：

创建表格

CREATE TABLE Students (
  StudentID INT PRIMARY KEY,
  Name VARCHAR(255),
  Age INT,
  Gender VARCHAR(10),
  Contact VARCHAR(255),
  Email VARCHAR(255),
  AccountInfo VARCHAR(255)
);

CREATE TABLE Teachers (
  TeacherID INT PRIMARY KEY,
  Name VARCHAR(255),
  Age INT,
  Gender VARCHAR(10),
  Contact VARCHAR(255),
  Email VARCHAR(255),
  AccountInfo VARCHAR(255)
);

CREATE TABLE Courses (
  CourseID INT PRIMARY KEY,
  Name VARCHAR(255),
  Description TEXT,
  Textbook VARCHAR(255),
  Video VARCHAR(255)
);

CREATE TABLE Assignments (
  AssignmentID INT PRIMARY KEY,
  Title VARCHAR(255),
  Description TEXT,
  Deadline DATE,
  CourseID INT,
  FOREIGN KEY (CourseID) REFERENCES Courses(CourseID)
);

CREATE TABLE Grades (
  GradeID INT PRIMARY KEY,
  StudentID INT,
  CourseID INT,
  Score DECIMAL(5,2),
  Comment TEXT,
  FOREIGN KEY (StudentID) REFERENCES Students(StudentID),
  FOREIGN KEY (CourseID) REFERENCES Courses(CourseID)
);

插入数据

INSERT INTO Students (StudentID, Name, Age, Gender, Contact, Email, AccountInfo)
VALUES (1, 'John Doe', 20, 'Male', '1234567890', 'john.doe@email.com', 'Account info goes here');

INSERT INTO Teachers (TeacherID, Name, Age, Gender, Contact, Email, AccountInfo)
VALUES (1, 'Jane Smith', 35, 'Female', '9876543210', 'jane.smith@email.com', 'Account info goes here');

INSERT INTO Courses (CourseID, Name, Description, Textbook, Video)
VALUES (1, 'Mathematics', 'Intro to Mathematics', 'Math Textbook', 'Math Video');

INSERT INTO Assignments (AssignmentID, Title, Description, Deadline, CourseID)
VALUES (1, 'Assignment 1', 'Complete exercises 1-5', '2022-01-31', 1);

INSERT INTO Grades (GradeID, StudentID, CourseID, Score, Comment)
VALUES (1, 1, 1, 90, 'Good job!');

查询数据

-- 获取所有学生的信息
SELECT * FROM Students;

-- 获取特定学生的信息
SELECT * FROM Students WHERE StudentID = 1;

-- 获取所有课程的信息
SELECT * FROM Courses;

-- 获取特定课程的信息及关联的作业
SELECT c.*, a.Title, a.Description, a.Deadline
FROM Courses c
JOIN Assignments a ON c.CourseID = a.CourseID
WHERE c.CourseID = 1;

-- 获取特定学生在特定课程的成绩
SELECT * FROM Grades WHERE StudentID = 1 AND CourseID = 1;

这些仅是基本的 SQL 语句示例，您可以根据需求进一步扩展和优化它们。请记得根据具体的数据库系统和表结构进行适当调整。