question: Tell me the outgoing manager for resigned and replaced by manolo villanova for real zaragoza
answer: SELECT outgoing_manager FROM table_name_29 WHERE manner_of_departure = "resigned" AND team = "real zaragoza" AND replaced_by = "manolo villanova"
context: CREATE TABLE table_name_29 (outgoing_manager VARCHAR, replaced_by VARCHAR, manner_of_departure VARCHAR, team VARCHAR)