If I've a transport table like this:transporttype | transportid
---------------+-------------Lorry | 1037Pickup | 1038Lorry | 1040Lorry
| 1045Pickup | 1046Lorry | 1047
How do I make a query so that I get a result like
transporttype | #of transport
---------------+-------------Lorry | 4Pickup | 2