Life Expectancy: Subquery

This is a query I used for analysis of a public Census Bureau international mortality and life expectancy dataset available in BigQuery. I used a subquery to determine the average life expectancy across all countries in 2022 while returning a list of countries with a life expectancy greater than the average.

Data source: “Mortality/Life Expectancy” table, 20 April 2017-26 July 2022, U.S. Census Bureau International Database, accessed via Google BigQuery.