The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
–1 vote
181 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 (116k points)
edited by | 181 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 (400k 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
49,443 questions
53,648 answers
186,099 comments
70,910 users