Table: eurovision_ireland_1997
Columns: draw
song
performer
points
rank

Question: What is the average number of points for a song ranked 2nd with a draw greater than 3?
SQL: SELECT AVG("points") FROM eurovision_ireland_1997 WHERE "rank" = '2nd' AND "draw" > 3

Question: What is the total number of draws for songs performed by Miranda with fewer than 48 points?
SQL: SELECT COUNT("draw") FROM eurovision_ireland_1997 WHERE "performer" = 'miranda' AND "points" < 48