Database: art_1
Question: What are the first names of all artists who have at least two paintings, and how many works did each create?
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