Hi guys!

I have a table with the next fields:

Lot --- Label ---- received
4848 -- 001 ---- t
4848 -- 002 ---- t
4848 -- 003 ---- f
4848 -- 004 ---- t
4048 -- 005 ---- t
4048 -- 006 ---- t
4048 -- 007 ---- f

I need a sql command that returns the next dataset:
Lote---labels---received
4848----4 ------ 3
4048----3 -------2

I'd really appreciate it any kind of help !

Best Regards
Martin