Hello, I am trying to query a table for all unique ID's that have an average of "10". carrier_id rating ============= 34 10 36 8 30 9 34 10 My result should be carrier_id 34 as it is the only carrier with an average rating of 10. Any ideas - I am king of stomped ... TIA. -Kevin