Selection: High-GPA Students
Easysql
Write a query implementing the Selection σ(gpa >= 3.5)(students) — return id, name, department, and gpa for every student with a gpa of at least 3.5, ordered by id.
sqlCREATE TABLE students ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, department TEXT NOT NULL, gpa DECIMAL(3,2) NOT NULL );
Sample data (this is what your query runs against when you press Run):
sqlINSERT INTO students (id, name, department, gpa) VALUES (1, 'Asha', 'Engineering', 3.8), (2, 'Rohan', 'Engineering', 3.2), (3, 'Neha', 'Sales', 3.6), (4, 'Vikram', 'Sales', 2.9), (5, 'Priya', 'Engineering', 3.9);
Example 1
Input
(none)
Output
id name department gpa 1 Asha Engineering 3.80 3 Neha Sales 3.60 5 Priya Engineering 3.90
A WHERE clause is Selection's direct SQL equivalent. Reference: SELECT id, name, department, gpa FROM students WHERE gpa >= 3.5 ORDER BY id;