The constructs you need are
GROUP BY[
^]
which means you can then use the
MAX[
^] function
Hint: If you were to add some additional data for one of the couriers e.g.
insert into Courier_tracking values( 1, '2014-07-26 12:18:37.813', 'In Process')
you can check for the requirement you mentioned "daily basis" if you look up
CAST[
^]E.g.
CAST(UpdationDate as date)
will help you get daily results such as
1 2014-07-25 July, 25 2014 15:58:37+0000
1 2014-07-26 July, 26 2014 12:18:37+0000
I'm not going to give you much more as this looks like homework. Have a go and come back if you get into difficulty