Question

Count how many rows are present in the airlines table.

Calculate the average elevation in the airports tables.
Calculate the maximum and minimum elevations in the airports table.
Calculate the average elevation, grouped by country id, in the airports table.
Calculate the average elevation, grouped by country id, in the airports table ordered by country id.
Calculate the average elevation, grouped by country id, in the airports table ordered by the average elevation in descending order.
Calculate the average elevation, grouped by country id, in the airports table ordered by the average elevation in descending order for any country that has an average elevation of at least 300.
Provide the query to determine how many aircrafts does "Boeing" (name) have a description that starts with "74".
Provide the query to determine how many different wake sizes do "Boeing" and "Airbus" have?
Provide the query to determine how many active airlines are present in Canada. You will need 2 queries.
SQL Commands

Answer 1

The question pertains to conducting hypothesis tests and examining data variability in airline operations, using statistics to analyze and plot real-world data for meaningful insights.

Step-by-step explanation:

The student's question is related to the field of Statistics, with a focus on conducting hypothesis tests and understanding data variability, as it pertains to real-world situations like airline flight data and seating capacities. The question encompasses the use of statistical methods to make inferences about populations based on sample data. It includes conducting a hypothesis test regarding the average number of babies on flights, estimating the mean number of unoccupied seats per flight using a sample, and how to organize and plot data for analysis.