students_report_by_geography.sql

# Write your MySQL query statement below

SELECT
  America, Asia, Europe
FROM
  (SELECT @as:=0, @am:=0, @eu:=0) t,
  (SELECT
     @as:=@as + 1 AS asid, name AS Asia
   FROM
     student
   WHERE
     continent = 'Asia'
   ORDER BY Asia) AS t1
  RIGHT JOIN
  (SELECT
     @am:=@am + 1 AS amid, name AS America
   FROM
     student
   WHERE
     continent = 'America'
   ORDER BY America) AS t2 ON asid = amid
  LEFT JOIN
  (SELECT
     @eu:=@eu + 1 AS euid, name AS Europe
   FROM
     student
   WHERE
     continent = 'Europe'
   ORDER BY Europe) AS t3 ON amid = euid;