Database: art_1
Question: What is the painting count of the artist with the longest life ?
SQL:
select count(*) from artists as t1 join paintings as t2 on t1.artistid  =  t2.painterid group by t2.painterid order by t1.deathyear - t1.birthyear desc limit 1