102 views

Consider a relation $\text{examinee (regno, name, score)},$ where regno is the primary key to score is a real number.

Suppose the relation $\text{appears (regno, centr_code)}$ specifies the center where an examinee appears. Write an SQL query to list the centr_code having an examinee of score greater than $80.$

edited | 102 views
0
question looks incomplete.

+1 vote
SELECT centr_code
FROM appears
WHERE regno IN (SELECT regno
FROM examinee
WHERE score > 80)