Hey, I started with right fucntion only, can anyone explain why it's not working

select right(name,3) from students where marks > 75 order by ID asc ;