Hello! Can you tell me how many total nominees there are?
select count ( artwork_id ) from nomination
Excellent!  For each nomination can you show me the name of the artwork associated with it, and the name of the festival where it was nominated?
select t2.name, t3.festival_name from nomination as t1 join artwork as t2 on t1.artwork_id = t2.artwork_id join festival_detail as t3 on t1.festival_id = t3.festival_id
Thanks!  Can you update this list to show all of the associated years for each of these festivals?
select t2.name, t3.festival_name, t3.year from nomination as t1 join artwork as t2 on t1.artwork_id = t2.artwork_id join festival_detail as t3 on t1.festival_id = t3.festival_id