Practice Problems - Mixed-up Code¶
Let’s practice what we have learned about SQL.
Please write a SELECT statement to retrieve the
english of all entries whose
english is lower than 60 and
math is higher than 90.
Create a SELECT statement to retrieve the
english for all entries whose
english value is lower than 60 and
math value is higher than 90.
A student completed an extra assignment and got some additional points.
Create an UPDATE statement to change the entry with a
student_id of 1 and set the math score for the
final to 90.
One test was too difficult so the instructors decided to give everyone extra points.
Create an UPDATE statement to add 10 points to the
of the entries with a
Create an INSERT statement to add a new entry to the
student_id to 4,
test_name to “midterm” ,
english score to 90 and
math score to 95.
CREATE TABLE statement to create a
grades table with
student_id of type integer, a
test_name of type text,
english score of type integer and a
math score of type