Database: art_1
Question: Find the top 3 artists who have the biggest number of painting works whose medium is oil?
SQL:
SELECT T1.lname ,  T1.fname FROM artists AS T1 JOIN paintings AS T2 ON T1.artistID  =  T2.painterID WHERE T2.medium  =  "oil" GROUP BY T2.painterID ORDER BY count(*) DESC LIMIT 3