I have one "orders" table:

```
ID  CustomerID  Freight
1      VINET      32.38
2      TOMPS      11.61
.        .          .
.        .          . 
.        .          .

```

I want to select just those customerID s that have freight more than average!!

```
SELECT CustomerID FROM Orders WHERE CustomerID IN(SELECT CustomerID,AVG(Freight) AVGFreight FROM Orders Group By CustomerID )

```

I know till here but how can I compare freight with the average!?? please help me thanks