task 3

SELECT Upper(`Name`), Lower(`Team`) FROM `Soccer_Players`

SELECT Team, substring(Team, 2, 6) FROM Soccer_Players

SELECT Name, Upper(substring(Name, 1, 4)),Team, Lower(substring(Team, 2, 6))  FROM Soccer_Players