Find the minimum value in the nested array column 'scores' for each user in the users table.
CREATE TABLE users (id INTEGER, name VARCHAR, scores INTEGER[]); INSERT INTO users (id, name, scores) VALUES (1, 'Alice', [85, 90, 78]), (2, 'Bob', [88, 92, 80]), (3, 'Charlie', [82, 89, 75]);
```sql
SELECT id, name, MIN(scores) AS min_score
FROM users
CROSS JOIN UNNEST(scores) AS t(score)
GROUP BY id, name;
```
```sql
SELECT id, name, MIN(scores) AS min_score
FROM users
CROSS JOIN UNNEST(scores) AS t(score)
GROUP BY id, name;
```