How many exhibitions have an attendance of more than 100?
select count ( * ) from exhibition_record as t1 join exhibition as t2 on t1.exhibition_id = t2.exhibition_id where t1.attendance > 100
How many exhibitions have a ticket price below 10?
select count ( * ) from exhibition_record as t1 join exhibition as t2 on t1.exhibition_id = t2.exhibition_id where t2.ticket_price < 10
What are the dates of the exhibitions who have an attendance of more than 100?
select t1.date from exhibition_record as t1 join exhibition as t2 on t1.exhibition_id = t2.exhibition_id where t1.attendance > 100
What was the theme of the party held in the latest year?
select theme from exhibition order by year desc limit 1
What was the ticket price of that party?
select ticket_price from exhibition order by year desc limit 1