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.
This section focuses on daily passenger travel. Results from the 2001 NHTS show that daily travel in the United States totaled about 4 trillion miles (table 2, table A-8), an average of 14,500 miles per person per year.On a daily basis, the average person traveled 40 miles, most of it (35 miles) in a personal vehicle.Because more than one person can travel in a personal vehicle, these 35 person miles amounted to about 23 vehicle miles traveled. Annually, the total number of vehicle miles traveled in 2001 was nearly 2.3 trillion.his section focuses on daily passenger travel. Results from the 2001 NHTS show that daily travel in the United States totaled about 4 trillion miles (table 2, table A-8), an average of 14,500 miles per person per year.