It’s rare that you can boil the solution for such a complex subject down into a single sentence. But with transportation, the zero-carbon future is basically this: Use electricity to run all the vehicles we can, and get cheap alternative fuels for the rest.
