Possible Quires

order by final_score; || where GP_ID=' '; || where health-DMG<=0 and M_owner in ( select GP_ID from weapon where W_owner in( select GP_ID from ship where GP_ID in (select GP_ID from gamepiece where used_in=' '))) group by M_owner order by count(*); || group by W_owner order by Max(W_level); || group by target; || from ship a,missile where health-DMG<=0 and M_owner in ( select GP_ID from weapon where W_owner in ( select GP_ID from ship b where a.GP_ID=b.GP_ID )) group by a.GP_ID; || (select GP_ID from Gamepiece where used_in=''); --as sum select count(*) from missile where health-DMG<=0 and target in (select GP_ID from Gamepiece where used_in=''); --as # of enemy which was killed So the conclusion is sum-#of enemy which was killed. || from gamepiece a left outer join missile on a.GP_ID=missile.GP_ID where M_owner in ( select weapon.GP_ID from weapon where W_owner in ( select b.GP_ID from gamepiece b where a.type=b.type ))group by a.type; ||
 * ~ Concept ||~ actual quire ||
 * < look for who has the highest final score among the players: ||< select played_by, final_score from Game
 * < look for the damage of each missile ||< select GP_ID, DMG from missile; ||
 * < look for the health remaining of a target and the DMG of missile before being hitted by a certain missile: ||< select Target, Health, DMG from missile
 * < count which weapon kill the most enemies for ship in one given game. ||< select M_owner, count(*) from missile
 * < look for the weapon owner who have the highest level of weapon ||< select W_owner, Max(W_level)from weapon
 * < look for how many times the target be hitted. ||< select target,count(health) from missile
 * < look for how long one player play each game ||< select played_By, runtime from Game; ||
 * < look for how many enemy one ship kills ||< select a.GP_ID, count(health) as number_of_kills
 * how many enemy ships where alive at the time of game over for a given game. || select count(*) from enemy where GP_ID in
 * < total number of missiles fired before death for each enemy type ||< select a.type, count(missile.GP_ID)
 * average number of missiles fired before death for each enemy type ||  ||