How can we help?

SELECT name, number_grade, ROUND(fraction_completed * 100) as percent_completed from student_grades ;

CASE
WHEN number_grade>90 THEN "A"
WHEN number_grade>80 THEN "B"
WHEN number_grade>70 THEN "C"
ELSE "F"

select count(*),
CASE
WHEN number_grade>90 THEN "A"
WHEN number_grade>80 THEN "B"
WHEN number_grade>70 THEN "C"
ELSE "F"

is my final code. it works.

you forgot the the case to count by.

SELECT name, number_grade, Round(fraction_completed*100)as percent_completed from student_grades ;
CASE
WHEN number_grade>90 THEN "A"
WHEN number_grade>80 THEN "B"
WHEN number_grade>70 THEN "C"
ELSE "F"

My final after step2/2 is:

CREATE TABLE student_grades (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
fraction_completed REAL);

VALUES ("Winston", 90, 0.805);
VALUES ("Winnefer", 95, 0.901);
VALUES ("Winsteen", 85, 0.906);
VALUES ("Wincifer", 66, 0.7054);
VALUES ("Winster", 76, 0.5013);
VALUES ("Winstonia", 82, 0.9045);
SELECT name, number_grade, ROUND(fraction_completed*100) AS percent_completed FROM student_grades;
SELECT COUNT(*),
CASE
WHEN number_grade > 90 THEN 'A'
WHEN number_grade > 80 THEN 'B'
WHEN number_grade > 70 THEN 'C'
ELSE 'F'

SELECT COUNT(*),
CASE
WHEN number_grade > 90 THEN 'A'
WHEN number_grade > 80 AND number_grade <= 90 THEN 'B'
WHEN number_grade > 70 AND number_grade <= 80 THEN 'C'
ELSE 'F'
END

My resolution after a little bit of research was the one below

STEP 1

SELECT name, number_grade, ROUND(fraction_completed * 100) as percent_completed

STEP 2

(Any coma or AS placed wrong will not allow it to proceed).

I was using AS in the ELSE "ELSE AS "F"" as it was not allowing me to complete.

SELECT COUNT(*),
CASE
WHEN number_grade > 90 THEN "A"
WHEN number_grade > 80 THEN "B"
WHEN number_grade > 70 THEN "C"
ELSE "F"