TASK 1

Q1

Pasted image 20250328142525.png

Pasted image 20250328143345.png

Pasted image 20250328143926.png

Pasted image 20250328145158.png
Pasted image 20250328150207.png
Pasted image 20250328150818.png

Pasted image 20250328150649.png
Pasted image 20250328150912.png
Pasted image 20250328150841.png

Pasted image 20250328151213.png
Pasted image 20250328151220.png

Pasted image 20250328155136.png
Pasted image 20250328155149.png

Pasted image 20250328160112.png

Pasted image 20250328160404.png
不可以，因为我创建视图时用了 distinct，而 distinct 的视图是不可插入的

Pasted image 20250328160848.png

Pasted image 20250328161058.png
不能，因为没有给出性别，没能通过检查