CREATE TABLE table_name_88 (date VARCHAR2, team VARCHAR2, player VARCHAR2)

On which date did Ger Loughnane from Team Clare have a match?
SELECT date FROM table_name_88 WHERE team = "clare" AND player = "ger loughnane"
SELECT "date" FROM "table_name_88" WHERE "clare" = "team" AND "ger loughnane" = "player"