The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
–1 vote
160 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.$ 

asked in Databases by Veteran (112k points)
edited by | 160 views
0
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 (369k points)

Related questions



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

44,337 questions
49,836 answers
164,752 comments
65,874 users