1 SELECT: specifies which columns in database tables to include in the result or result set. 2  FROM: specifies the tables that you want to query data from. You can also use the FROM clause to join multiple tables. 3  WHERE: filters unwanted records or rows in the result.  GROUP BY: groups rows by common column values.
In the year 2010 there were 631,939,829 total passengers that  boarded flights according to the Bureau of Transportation  Statistics. The average number of people that fly pâ¦er day in the  United States is around 1.73 million.
On a recent trip, I observed the activity around me and wondered how many people actually pass through airports each year. In case youâve ever pondered this, hereâs a look at the domestic and international fronts regarding how many passengers fly each year, and the busiest U.S. airlines and airports. *Note: The information that follows relates to the first seven months of 2008.