Consider the SQL query whose answer is shown in Figure 3.2. Sid Name Login

Question:

Consider the SQL query whose answer is shown in Figure 3.2.
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  book-img-for-question

Database management systems

ISBN: 978-0072465631

3rd edition

Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff

Question Posted: