Cars with Above Average Engine Size
 

Using the table playground.automobile, Create a SQL query to identify cars that have an engine size above the average across all cars in the dataset. The result should include the brand, fuel_type, and engine size, ordered by engine size in descending order and then brand_name in asc order.

These are the tables to query for this question:
playground.automobile
  • brand_name string
  • fuel_type string
  • aspiration string
  • door_panel string
  • design string
  • wheel_drive string
  • engine_location string
  • engine_type string
  • cylinder_count string
  • engine_size int
  • fuel_system string
  • bore double
  • stroke double
  • compression_ratio double
  • horse_power int
  • top_RPM int
  • city_mileage int
  • highway_mileage int
  • price_in_dollars int
Your answer should include these columns:
  • brand_name varchar
  • fuel_type varchar
  • engine_size integer

Querying is only for logged in users!

Write Your Query Here (you can run selections by highlighting!)

Query Results

No queries have been run yet.