select * from gamba_yeardata where gscore >= opponentscore and referee="家本 政明";
同様に、負けたゲームの検索
select * from gamba_yeardata where gscore < opponentscore and referee="家本 政明";
例4
2001年のガンバ戦、スコアと対戦相手、スタジアムの現在の名称と当時の名称を列挙してみる
select gamba_yeardata.gscore,gamba_yeardata.opponentscore,gamba_yeardata.opponentname,stadium_tbl.currentname,stadium_tbl.thenname from gamba_yeardata inner join stadium_tbl on gamba_yeardata.stadium = stadium_tbl.shortname where year=2001;