Computer scienceFundamentalsSQL and DatabasesBasics SQLRetrieving Data

The WITH statement

CTE imlementation

Report a typo

We have a table student_results with students' points for entry exams and the maximum possible amount of points.

student name	points	maximum points possible
John B.	376	400
Kate O.	350	400
Mary P.	388	400
Michael M.	320	400
Sam W.	390	400

Choose a correct code with a CTE expression that returns a column with the percentage of students' points.

Select one option from the list

 WITH points_percentage(student name, percentage, maximum points posible )  AS  ( SELECT student name,     (points/ maximum points possible*100)  percentage,  maximum points possible  FROM student_results )

WITH points_percentage(student name, percentage, maximum points posible )  AS  ( SELECT student name,     (points/ maximum points possible*100)  percentage,  maximum points possible  FROM student_results )  SELECT * FROM  points_percentage

 WITH points_percentage(student name, percentage, maximum points posible   SELECT student name,     (points/ maximum points possible*100)  percentage,  maximum points possible  FROM student_results )  SELECT * FROM  points_percentage

___

Create a free account to access the full topic