The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
–1 vote

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.$ 

asked in Databases by Veteran (103k points)
edited by | 132 views
question looks incomplete.

1 Answer

+4 votes
SELECT centr_code
FROM appears
WHERE regno IN (SELECT regno
               FROM examinee
               WHERE score > 80)
answered by Veteran (359k points)

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true

41,055 questions
47,656 answers
62,380 users