SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
select name, CASE WHEN grade>=70 THEN 'C', WHEN grade>=80 THEN 'B', WHEN grade>=90 THEN 'A', ELSE 'D' END grade_outcome FROM Students;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear