It is, however I was able to get the first 8 done, I am struggling with these 3 particular ones. I have to make an SQL file based off of it, so this seems to be a blockage in my works.
-----Original Message----- From: Gary Herron [mailto:gher...@islandtraining.com] Sent: Thursday, February 26, 2009 1:46 AM To: mmcclaf; python-list@python.org Subject: Re: Queries mmcclaf wrote: > I have to make some queries for 4 tables I have. The following > relations are: > > Classes(class, type, country, numGuns, bore, displacement) > Ships (name, class, launched) > Battles (name, date) > Outcomes (ship, battle, result) > > The three queries I'm stuck on are the following: > > 1. Find the classes that have only one ship as a member of that class > (not all ships are listed in the Ship table) > 2. Find the countries that had both battleships and battlecruisers > (those fall under type in Classes) > 3. Find those ships that "lived to fight another day"; they were > damaged in one battle, but later fought in another. > > The best way for me to understand would be relational algebra for each > of the statements. > Sounds like a homework assignment. Good luck with it. > Any help in this would be greatly appreciated. > -- > http://mail.python.org/mailman/listinfo/python-list > No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.0.237 / Virus Database: 270.11.3/1971 - Release Date: 02/25/09 06:40:00 -- http://mail.python.org/mailman/listinfo/python-list
