CREATE TABLE visit (name VARCHAR, Museum_ID VARCHAR, museum_id VARCHAR); CREATE TABLE museum (name VARCHAR, Museum_ID VARCHAR, museum_id VARCHAR)
What is the name of the museum that had no visitor yet?
SELECT name FROM museum WHERE NOT Museum_ID IN (SELECT museum_id FROM visit)