I'm very new to SQL so apologies in advance if I'm missing the obvious. 

My data consists of customer contract number, service date, and a list of prices. I need to be able to group by customer, pull the first price by service date and in another column have the sum of all prices.

So I have something like: 

```
SELECT
CONTRACT, 
SUM(PRICES) as [TOTAL SPENT]
FIRST(PRICE) as [FIRST PRICE]
FROM TABLE
GROUP BY CONTRACT
ORDER BY CONTRACT

```

But apparently First is not a built in function name (I'm using Microsoft SQL Server). Any suggestions?

Thanks in advance!