A database interrogation is a major benefit of the database management approach,

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

And the result of the above query is:

STUDENT_NAME

COURSE_ID

Bader Ali

IT101

Salman Abdulaziz

IT242

Based on the above STUDENTS table, answer the following questions:

Write an SQL query to retrieve STUDENT_ID and STUDENT_GPA for all CCI students who study the course has the code IT101.

What is the result of the following query?

SELECT [STUDENT_ID], [COURSE_ID], [COLLEGE_CODE]

FROM [STUDENTS]

WHERE [COURSE_ID] = “IT242” OR [STUDENT_GPA] > 3.00

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

Explanation / Answer

Hi,
1.
To get names and GPA of students with college code CCI and course Id IT101, we need to use the AND clause withing the where like below,

SELECT [STUDENT_NAME], [STUDENT_GPA]

FROM [STUDENTS]

WHERE [COLLEGE_CODE] = 'CCI' AND  [COURSE_ID] = 'IT101'

2.

SELECT [STUDENT_ID], [COURSE_ID], [COLLEGE_CODE]

FROM [STUDENTS]

WHERE [COURSE_ID] = “IT242” OR [STUDENT_GPA] > 3.00
this will give us all students with their id, course id and college code who belong to course 1T242 OR have gpa>3 i.e it will return
140064001 IT101 CHS
140064003 IT242 CCI
140064004 IT446 CCI
140064007 IT242 CCI

Thumbs up if this was helpful, otherwise let me know in comments

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.