Re: SQl query

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.