Hi Abdul,
> How do I make a query so that I get a result like>> transporttype | #of transport> ---------------+-------------> Lorry | 4> Pickup | 2
SELECT transporttype, count(*) FROM transport GROUP BY transporttype;
Cheers
Matthew.