sql - How can I extract values where there are repeated values of fields?

Question

From the following table,

userId passageId score
1      1         2
1      2         3
1      1         4
2      1         3
2      3         3
2      3         4

is it possible to extract the scores as shown below when the first two values of passageId are identical for each value of userId.

userId passageId score_1 score_2 
1      1         2          4
2      3         3          4

question from:https://stackoverflow.com/questions/65905792/how-can-i-extract-values-where-there-are-repeated-values-of-fields

Answer 1

DBFIDDLE

SELECT 
   userId,
   passageId,
   min(score) as score_1,
   max(score) as score_2
FROM mytable
GROUP BY    
   userId,
   passageId
HAVING COUNT(*)>=2;