Write the following query with and without the GROUP BY clause: List all students with their corresponding average grade.
Consider the following ODL de?nitions:
class Person : Object
( extent PersonExt ):PERSISTENT;
{
attribute String Name;
... ... ...
}
class Student extends Person
( extent StudentExt ):PERSISTENT;
{
attribute Integer Id;
attribute SetTranscript;
... ... ...
}
struct TranscriptRecord {
String CrsCode;
float Grade;
String Semester;
}
SELECT S.Name, avg(flatten(S.Transcript).Grade)
FROM StudentExt S
SELECT S.Name, avg(T.Grade)
FROM StudentExt S, S.Transcript T
GROUP BY S
The second query just complicates things — all for the sake of being able to use GROUP BY.
You might also like to view...
Report controls can be formatted using the ________
A) Page Setup tab B) Relationships Report C) Group, Sort, and Total pane D) Property Sheet
A motherboard has two memory expansion slots colored blue and two memory expansion slots colored yellow. Which statement is most likely true for this motherboard?
A) The motherboard supports dual channel memory. B) The motherboard supports both DDR4 and DDR5 memory modules. C) The motherboard is in a server. D) The motherboard uses RIMMs.
RTF does not support which feature?
A. Font definitions B. Auto updated calculated fields C. Standard alignment options D. Basic formatting, such as bold and italics
Which commonly used programming language is used to manage, access, and search for database content?
What will be an ideal response?