Complex SQL Query or querries : I looked at other examples, but I don't know enough about SQL to adapt it to my needs.  I have a table that looks like this:

        ID	Month	NAME	COUNT	First	LAST	TOTAL
        1	JAN2013	fred	4
        2	MAR2013	fred	5
        3	APR2014	fred	1
        4	JAN2013	Tom	    6
        5	MAR2014 Tom	    1
        6	APR2014	Tom	    1



This could be in separate queries, but I need 'First' to equal the first month that a particular name is used, so every row with fred would have JAN2013 in the first field for example.  I need the 'Last" column to equal the month of the last record of each name, and finally i need the 'total' column to be the sum of all the counts for each name, so in each row that had fred the total would be 10 in this sample data.  This is over my head. Can one of you assist?
