CASE ของการแข่งขันคู่ปรับ

SELECT 
	date,
	CASE WHEN hometeam_id = 8634 THEN 'FC Barcelona' 
         ELSE 'Real Madrid CF' END as home,
	CASE WHEN awayteam_id = 8634 THEN 'FC Barcelona' 
         ELSE 'Real Madrid CF' END as away,
	-- Identify possible home match outcomes
	___ ___ home_goal > away_goal ___ hometeam_id = 8634 ___ 'Barcelona win!'
        WHEN home_goal < away_goal ___ awayteam_id = 8633 ___ 'Real Madrid win!'
        ___ 'Tie!' ___ ___ outcome
FROM matches_spain
WHERE hometeam_id = 8634 AND awayteam_id = 8633;