CREATE TABLE PersonFriend (friend VARCHAR(255), name VARCHAR(255)); CREATE TABLE Person (name VARCHAR(255))
How many friends does Dan have?
    
SQL: SELECT COUNT(T2.friend) FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name = T2.name WHERE T1.name = 'Dan'