Interview questions--A student with a SQL query score of not less than 80

CREATE TABLE Marklist
(
Name varchar (10),
Course varchar (10),
Mark float
)

Insert into Marklist (Name,course,mark) VALUES (' Zhang San ', ' math ', 75);
Insert into Marklist (Name,course,mark) VALUES (' John Doe ', ' language ', 76);
Insert into Marklist (Name,course,mark) VALUES (' John Doe ', ' math ', 75);
Insert into Marklist (Name,course,mark) VALUES (' Harry ', ' English ', 100);
Insert into Marklist (Name,course,mark) VALUES (' Harry ', ' language ', 81);

1: SELECT distinct name from Marklist where name is not in (select name from Marklist where Mark < 80)

2:select name from Marklist Group by name have min (Mark) > 80

Interview questions--A student with a SQL query score of not less than 80