question: What is the average rank of Great Britain when their total is over 4?
answer: SELECT AVG(rank) FROM table_name_80 WHERE total > 4 AND nation = "great britain"
context: CREATE TABLE table_name_80 (rank INTEGER, total VARCHAR, nation VARCHAR)