Consider the SQL query whose answer is shown in Figure 3.2. Sid Name Login
Question:
Sid
Name
Login
Age
Gpa
53831
Madayan
madayan@
11
1.8
53832
Gulda
guldu@music
12
2.0
Students with age < 18 on Instance S
1. Modify this query so that only the login column is included in the answer.
2. If the clause WHERE S.gpa > = 2 is added to the original query, what is the set of tuples in the answer?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Database management systems
ISBN: 978-0072465631
3rd edition
Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff
Question Posted: