1. Insert a student with minimal data (skip optional fields like address and phone), named Emily Clark, born on 2002-05-10, female, majoring in Psychology, enrolled in 2022, GPA 3.8.
2. Find all students currently marked as "Active".
3. List students majoring in "Computer Science" with a GPA above 3.5.
4. Update the status of a student with student_id = 5 to 'Graduated'.
5. Change the major of all students who enrolled in 2019 from "Business Administration" to "Information Management".
6. Remove all students who dropped out (status = 'Dropped') and have GPA lower than 2.5.
7. Show the full names and GPA of all students with a GPA greater than 3.0.

中文

1. 插入一筆最基本資料的學生（略過像地址和電話等選填欄位），名為 Emily Clark，出生於 2002-05-10，女性，主修心理學，2022 年入學，GPA 為 8。
2. 查詢目前標示為「在學」的所有學生。
3. 列出主修「電腦科學」且 GPA 高於 5 的學生。
4. 將 student_id 為 5 的學生狀態更新為「已畢業」。
5. 將所有 2019 年入學且主修「企業管理」的學生主修改為「資訊管理」。
6. 移除所有中途退學（狀態為「已退學」）且 GPA 低於 5 的學生。
7. 顯示 GPA 高於 0 的所有學生之全名與 GPA。

SELECT column1, column2 FROM table_nameWHERE [Condition];

Insert into demo (name) values ('Brian')

UPDATE table_nameSET column1=value1, column2=value2WHERE [condition]

DELETE FROM table_name WHERE [Condition]