Why won't this statement work? SQL

Why won't this statement work? SQL

I am using SQLFire. I am doing an assignment and when beginning the
assignment I came across that I couldn't return a particular value. See
this SQL Fiddle, it contains the EXACT data in the table that I am using
in my assignment and it contains the SQL Statement that seems to work in
SQL Fiddle. What is outputted in the SQL Fiddle is EXACTLY what I want.
FIDDLE: http://sqlfiddle.com/#!2/e761ac/1
It works PERFECTLY in SQL Fiddle, but I am getting this error when I type
the exact code into SQL Fire.
I Have been told NOT to use the ORDER BY clause and I have not learnt
'LIMIT' My question is very simple, I am just confused as to why I am
getting this error message in SQL Fire, yet it works perfectly in Fiddle,