Entirely dependent on what you mean by “table”. Is this HubDB or a custom table via the module? Either way… Just coallesce the results and display the sum. Your post is vague, but I’m assuming you want something like this?
{# rows = module.rows or some other accessor if a module... or rows = hubdb_table_rows(tableId, other parameters) #}
{% set rows = pick a referencing methodology.... #}
{# count = rows|selectattr("column name in HubDB table or field in module group", "equalto", "mode of transportation")|length . So maybe.... #}
{% set numCars = rows|selectattr("mode_of_transportation", "equalto", "car")|length %}
You can fill in the gaps… Or, add further detail.