PostgreSQL Exam PGCES-02 Topic 2 Question 65 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 65
Topic #: 2

[All PGCES-02 Questions]

The table "score" is defined as follows:

gid | score

-----+-------

1 | 70 1 |

60 2 | 100

3 | 80 3 |

The following query was executed. Select the number of rows in the result.

SELECT gid, max(score) FROM score GROUP BY gid HAVING max(score) > 60;

A1 row

B2 rows

C3 rows

D4 rows

E5 rows

Show Suggested Answer

Suggested Answer: A

by Ora at Jun 30, 2024, 10:22 AM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Hyman

7 days ago

I'm not sure, but I think the answer might be C) 3 rows because there are 3 unique gid values with max score greater than 60.

upvoted 0 times

...

Tracey

8 days ago

I agree with Enola, because there are 2 rows where the max score is greater than 60.

upvoted 0 times

...

Enola

10 days ago

I think the answer is B) 2 rows.

upvoted 0 times

...

Tori

12 days ago

I'm not sure, but I think the answer might be C) 3 rows because there are 3 unique gid values with max score greater than 60.

upvoted 0 times

...

Annamaria

14 days ago

I agree with Gayla, because there are 2 rows where the max score is greater than 60.

upvoted 0 times

...

Gayla

22 days ago

I think the answer is B) 2 rows.

upvoted 0 times

...