The First Generation Restyling Mazda CX-9 is a five-door family SUV. If you are comparing this generation, start with how its gasoline automatic powertrain and equipment examples work in daily driving.
The Mazda CX-9 engine shown here is a 3.7 gasoline unit with an automatic transmission and all-wheel drive. In daily use that powertrain favors loaded trips and wet-road confidence over economy. The 3.7 AT SUV 5-doors is a selected drivetrain example, not the full lineup.
SUV 5-doors — Mazda CX-9 Engines and Transmissions
Mazda CX-9 trim levels on the 3.7 AT include Sport, which adds cabin and convenience equipment to that gasoline automatic all-wheel-drive setup. Trims mainly change comfort and features, so Sport is an equipment configuration of the SUV 5-doors version, not a different powertrain.