Question

A database interrogation is a major benefit of the database management approach, where end users can query (“ask”) the database for information. The Structured Query Language (SQL) is an international standard query language found in many DBMS packages. The basic form of a SQL query is: SELECT . . . FROM . . . WHERE . . .
For example, if we have the following STUDENTS table:

STUDENT_ID STUDENT_NAME COURSE_ID STUDENT_GPA COLLEGE_CODE

140064001 Ahmad Nasser IT101 3.5 CHS

140064002 Sarah Abdullah IT343 2.75 CCI

140064003 Sultan Mohamed IT242 3.15 CCI

140064004 Basmah Khaled IT446 3.90 CCI

140064005 Bader Ali IT101 2.90 CHI

140064006 Fahad Mutlaq IT448 1.95 CCI

140064007 Salman Abdulaziz IT242 2.90 CCI


The following SQL query is used to retrieve STUDENT_NAME and COURSE_ID for all students who have GPA = 2.90


SELECT [STUDENT_NAME], [COURSE_ID]

FROM [STUDENTS]

WHERE [STUDENT_GPA] = 2.90

Answer 1

Bader Ali, IT101, from Ahmad Nasser where Bader Ali GPA=2.