SQL: how many people have more than 2 cars

I ask this question by example:

{table1}:

   person_id

{table2}:

   person_id
   car_id

each person has one entry in {table1} and zero, one or more entries in
{table2}.

I want to know how may people have more than 2 cars. Seems easy but I am missing something.

help?
Much thanks in advance.

Ben Received on Wed Apr 25 2001 - 07:58:39 CDT