> How do I make a query so that I get a result like
>
> transporttype | #of transport
> ---------------+-------------
> Lorry | 4
> Pickup | 2
=> select transporttype, count(transporttype) as "#of transport" from
transport group by 1;
regards,
bhuvaneswaran