use the "titanic" database and the "titanic3" table.

On April 10, 1912 a well known local Norwegian soothsayer Alfred Motsatte was heard in a Queenstown, Ireland bar rambling in an inebriated stupor and predicting the demise of Her Majestys finest ship. Take ye notice righhhhht here and now, Motsatte exclaimed as he sloshed his half-empty mug of bar swill, all women who board the Titanic in first class from Queenstown are doomed to perish in an icy grave and all men who accompany them will survive to become widowers.

Was he right?

2. Paste the SQL statement you used to determine whether Motsatte was right or wrong.

3. What lifeboat (boat number or letter) contained the most survivors? How many survivors did it contain?

4. Paste the SQL statement you used to determine the lifeboat and number of survivors.

5. How many survivors were in boat 12?

6. Paste the SQL query you used to determine the number of survivors in boat 12.