Need help to write the Query

[hiteshkataria]

I just treid for initial 3 field and could not think of rest.

This is what I tried:

SELECT Name, Count(Cost), Sum(Cost)
FROM ItemTab
Group  by Name
ORDER BY Name;