Question
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,
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database Systems For Advanced Applications 18th International Conference Dasfaa 2013 Wuhan China April 22 25 2013 Proceedings Part 2 Lncs 7826
Authors: Weiyi Meng ,Ling Feng ,Stephane Bressan ,Werner Winiwarter ,Wei Song
2013th Edition
3642374492, 978-3642374494
