I want to select the name and date of birth of all living artists who have
value more than 50. My tables are
picture and I wrote this SQL statement but it is not giving me the desired result. Please advise.
SELECT name, dateOfBirth FROM artist JOIN exhibitions.picture ON exhibitions.picture.name WHERE exhibitions.picture.value = '50' AND artist.dayOfDeath is NULL;