Table: ireland_captains_stats
Columns: player
dates_of_captaincy
lost
tied
no_result
win_a

Question: Which player has no 0 results and multiples ties?
SQL: SELECT "player" FROM ireland_captains_stats WHERE "no_result" = 0 AND "tied" > 0

Question: What is the low no result with more than 5 loss and a win ration lesser than 58.06?
SQL: SELECT MIN("no_result") FROM ireland_captains_stats WHERE "lost" > 5 AND "win_a" < 58.06