CREATE TABLE round (Member_ID VARCHAR, Rank_in_Round INT)
CREATE TABLE member (Name VARCHAR, Member_ID VARCHAR)

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" AS "T1" JOIN "round" AS "T2" ON "T1"."Member_ID" = "T2"."Member_ID" AND "T2"."Rank_in_Round" > 3