CREATE TABLE college (college_id NUMBER, name CLOB, leader_name CLOB, college_location CLOB)
CREATE TABLE member (member_id NUMBER, name CLOB, country CLOB, college_id NUMBER)
CREATE TABLE round (round_id NUMBER, member_id NUMBER, decoration_theme CLOB, rank_in_round NUMBER)

Show the names of members that have a rank in round higher than 3.
SELECT T1.name FROM member AS T1 JOIN round AS T2 ON T1.member_id = T2.member_id WHERE T2.rank_in_round > 3
SELECT "T1"."name" FROM "member" "T1" JOIN "round" "T2" ON "T1"."member_id" = "T2"."member_id" AND "T2"."rank_in_round" > 3