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

asked in Databases by Veteran (99.8k points)
edited by | 102 views
0
question looks incomplete.

1 Answer

+1 vote
SELECT centr_code
FROM appears
WHERE regno IN (SELECT regno
               FROM examinee
               WHERE score > 80)
answered by Veteran (355k 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

37,980 questions
45,481 answers
131,420 comments
48,452 users