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

An

2 months ago

This is a tricky one! I'm going to go with option B) 2 rows. The query is pretty straightforward, but you have to pay attention to that HAVING clause. And hey, at least it's not as confusing as that 'SELECT DISTINCT' question from last time, right?

upvoted 0 times

...

Latricia

2 months ago

Hmm, let me think this through. The table has 5 rows, and the query is grouping by gid, so there will be 3 groups. But the HAVING clause is filtering out the groups where the max score is less than 60, so the answer must be 2 rows.

upvoted 0 times

Teri

9 days ago

So, the final result will have 2 rows.

upvoted 0 times

...

Arthur

16 days ago

That makes sense. The HAVING clause filters out the groups with max score less than 60.

upvoted 0 times

...

Rodney

29 days ago

Yes, I agree. The query will return 2 rows.

upvoted 0 times

...

Jerrod

2 months ago

I think the answer is B) 2 rows.

upvoted 0 times

...

Layla

2 months ago

I'm pretty sure the answer is 2 rows. The table has 5 rows, but the query is only selecting the groups where the max score is greater than 60, and there are only 2 such groups.

upvoted 0 times

Zachary

19 days ago

So, the result will only include the groups with max score greater than 60, which are 2 rows.

upvoted 0 times

...

Zana

24 days ago

Yes, the query is filtering out the groups with max score less than 60.

upvoted 0 times

...

Dorothea

1 months ago

I think you're right, it should be 2 rows.

upvoted 0 times

...

Ronald

2 months ago

The query is grouping by gid and selecting the maximum score for each group, but it's also filtering out the groups where the maximum score is less than 60. So, the result should have 3 rows, one for each group with a max score greater than 60.

upvoted 0 times