Queries

[Murray]

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:gherron at islandtraining.com] 
Sent: Thursday, February 26, 2009 1:46 AM
To: mmcclaf; python-list at 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