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.
1 Answer. The total US domestic market is 629,457,532 scheduled passengers per year. It is true that Delta carried the most total passengers in 2010, but that includes BOTH international and domestic passengers. For domestic only, Southwest was the largest carrier in the US.