CREATE TABLE ship (lost_in_battle VARCHAR(255), name VARCHAR(255)); CREATE TABLE battle (name VARCHAR(255), date VARCHAR(255), id VARCHAR(255))
List the name and date the battle that has lost the ship named 'Lettice' and the ship named 'HMS Atalanta'
    
SQL: SELECT T1.name, T1.date FROM battle AS T1 JOIN ship AS T2 ON T1.id = T2.lost_in_battle WHERE T2.name = 'Lettice' INTERSECT SELECT T1.name, T1.date FROM battle AS T1 JOIN ship AS T2 ON T1.id = T2.lost_in_battle WHERE T2.name = 'HMS Atalanta'