Try me

In these exercises, you must use SQL queries to answer the questions. Enter your SQL statements in the corresponding markdown cell.

1. Create a database named edem_programming

-- Insert you answer here

2. Create a table named Students. Students must have an identifier, a name, a continuous evaluation grade, and a written exam grade. You may add additional information elements you consider important. Choose the best type for each field in your data model.

-- Insert you answer here

3. Insert into the table several rows of students. This is your chance to grade your individual performance on the course.

-- Insert you answer here

4. Design a select query to select all students that have a continuous evaluation grade higher than five

-- Insert you answer here

5. Design a select query to select all students that pass the course (continuous evaluation higher than five and written examination higher than five)

-- Insert you answer here