need help with SQL again, count method
From: Jerry Parmeley <jparmeley_at_hotmail.com>
Date: Sat, 17 Feb 2001 18:31:21 -0600
Message-ID: <t8u5rt44s86h11_at_corp.supernews.com>
Date: Sat, 17 Feb 2001 18:31:21 -0600
Message-ID: <t8u5rt44s86h11_at_corp.supernews.com>
i have my silly airport database again.
i am attempting to find out how to answer the questions:
What type of Jet arrives at Airport number 1 the most? What flight has the most passengers on it? What type of Jet moves the most people from one airport to another? How many passengers under age of 10 leave airport 1? Who is the tallest person to fly on Jet type 1?
i know it is hard to do without looking at the database; however, assume that i have the database built and all keys properly indicated.
i am assuming that some of these queries will use a count method. but i am unsure.
help is appreciated.
jerry Received on Sun Feb 18 2001 - 01:31:21 CET