Francisco Cruz

rearrange columns and use aliases

Task 1

  • November 17, 2016 at 3:40 PM
  • Visible to public
/*Task 1"*/

SELECT concat(Name, ' is on the team ', Team) name_team from Soccer_Players

SELECT name, `Salary(Millions)` from Soccer_Players order by `Salary(Millions)`