사진도 흐리고 내용 보기 힘드네요. 

설명도 넣어서  다시 올려주세요.

-- 1. 
SELECT a.season_year
     , b.player_name
   FROM season a
  INNER JOIN player b
     ON a.purple_cap = b.player_id
--  WHERE a.season_year >= 2009
--    AND a.season_year <= 2016
 ORDER BY a.season_year
;

-- 2. 
SELECT country_code
  FROM cities
 WHERE country_code IN (SELECT code FROM economies
                         UNION
                        SELECT code FROM currencies)
   AND country_code NOT IN (SELECT country_code FROM populations)
;

-- 3. 
SELECT *
  FROM populations
 WHERE life_expectancy > 1.15 * (SELECT AVG(life_expectancy)
                                   FROM populations
                                  WHERE year = 2015
                                 )
   AND year = 2015
;

-- 2. 
SELECT country_code FROM cities
 INTERSECT
(
SELECT code FROM economies
 UNION
SELECT code FROM currencies
)
EXCEPT
SELECT country_code FROM populations
;

너무 감사합니다!!!!!!