CREATE TABLE betfront (year NUMBER, datetime TIME, country CLOB, competion CLOB, match CLOB, home_opening NUMBER, draw_opening NUMBER, away_opening NUMBER, home_closing NUMBER, draw_closing NUMBER, away_closing NUMBER)
CREATE TABLE football_data (season CLOB, datetime TIME, div CLOB, country CLOB, league CLOB, referee CLOB, hometeam CLOB, awayteam CLOB, fthg NUMBER, ftag NUMBER, ftr CLOB, hthg NUMBER, htag NUMBER, htr CLOB, psh NUMBER, psd NUMBER, psa NUMBER, b365h NUMBER, b365d NUMBER, b365a NUMBER, lbh NUMBER, lbd NUMBER, lba NUMBER, bwh NUMBER, bwd NUMBER, bwa NUMBER)

What are the Pinnacle odds for Arsenal winning matches?
SELECT psh FROM football_data WHERE hometeam LIKE "%Arsenal%" AND ftr = "H" UNION SELECT psa FROM football_data WHERE awayteam LIKE "%Arsenal%" AND ftr = "A"
SELECT "psh" FROM "football_data" WHERE "H" = "ftr" AND "hometeam" LIKE "%Arsenal%" UNION SELECT "psa" FROM "football_data" WHERE "A" = "ftr" AND "awayteam" LIKE "%Arsenal%"