Database: art_1
Question: Find the first names and number of works of all artists who have at least two paintings?
SQL:
SELECT T1.fname ,  count(*) FROM artists AS T1 JOIN paintings AS T2 ON T1.artistID  =  T2.painterID GROUP BY T2.painterID HAVING count(*)  >=  2