If we issue a query of the form What terms can appear in the HAVING condition (r

Question

If we issue a query of the form

What terms can appear in the HAVING condition (represented by ??? in the above query)? Identify, in the list below, the term that CAN NOT appear.

If we issue a query of the form

What terms can appear in the SELECT list (represented by ??? in the above query)? Identify, in the list below, the term that CAN NOT appear.

Scores(Team, Day, Opponent, Runs)

Gives the scores in the Japanese Baseball League for two consecutive days. The Opponent is NULL if the Team did not play on that day. The number of Runs is given as NULL if either the team did not play, or will play on that day but the game is not yet concluded. The data in this table is as follows:

What is the result of the following query?

Note: When a column has a string type, Min and Max refer to lexicographic (alphabetic) order of strings. That is, Min(Opponent) is the opponent that comes first in alphabetical order, and Max(Opponent) would be the one that comes last in alphabetical order.

Identify in the list below one of the tuples in the result.

Scores(Team, Day, Opponent, Runs)

Gives the scores in the Japanese Baseball League for two consecutive days. The data in this table is as follows:

Determine the result of the query

Then, identify, in the list below, one of the tuples of the result.

Which of the following tuples is in the result?

Compute the result of the query:

Identify, in the list below, the row that appears in the result.

Scores(Team, Day, Opponent, Runs)

Gives the scores in the Japanese Baseball League for two consecutive days. The Opponent is NULL if the Team did not play on that day. The number of Runs is given as NULL if either the team did not play, or will play on that day but the game is not yet concluded. The data in this table is as follows:

What is the result of the following query?

Then, identify in the list below one of the tuples in the result.

       R(A, B, C, D, E)  

If we issue a query of the form

       SELECT ...       FROM R       WHERE ...       GROUP BY B, E       HAVING ???  

What terms can appear in the HAVING condition (represented by ??? in the above query)? Identify, in the list below, the term that CAN NOT appear.

Explanation / Answer

1)

answer: A cannot appear unaggregated

Here in the options i cannot able to see the A option but the answer is A and with that i can say option b is the answer because it also cannot be unaggreated

2)

SELECT ???

FROM R

WHERE ...

GROUP BY C, D

fot this select statement E cannot be opper

answer: E cannot appear in the SELECT list

3)

SELECT Team, Min(Opponent), Max(Runs)

FROM Scores

GROUP BY Team

answer: Carp Dragons NULL

4) The table Scores(Team, Day, Opponent, Runs) havong the team day opponent and runs columns and

SELECT Team, SUM(Runs)

FROM Scores

GROUP BY Team

answer: Swallows 10

5) (1,2), (1,2), (2,3), (3,4), (3,4), (4,1), (4,1), (4,1), (4,2). these are the sets given and by using the below query we are getting

SELECT a1.x, a2.y, COUNT(*)

FROM Arc a1, Arc a2

WHERE a1.y = a2.x

GROUP BY a1.x, a2.y;

answer: 3,4,2

6) here we have the R(A,B), S(C,D), and T(E,F) relations so by using the following query we are taking the R set ant S and T sets   

SELECT A, F, SUM(C), SUM(D)

FROM R, S, T

WHERE B = C AND D = E

GROUP BY A, F

HAVING COUNT(*) > 1

answer: (1,1,1,2)

7)Form the table Scores(Team, Day, Opponent, Runs) we are selecting the

SELECT Opponent, COUNT(*), AVG(Runs)

FROM Scores

GROUP BY Opponent

so finally we will get the following result

answer: Carp4.333

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.