CREATE TABLE countrylanguage (CountryCode VARCHAR(255), Language VARCHAR(255), IsOfficial VARCHAR(255)); CREATE TABLE country (Name VARCHAR(255), Code VARCHAR(255))
What are the names of nations where both English and French are official languages?
    
SQL: SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "English" AND T2.IsOfficial = "T" INTERSECT SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "French" AND T2.IsOfficial = "T"