15 lines
225 B
SQL
15 lines
225 B
SQL
WITH skill_names AS (
|
|
SELECT
|
|
"index" AS "id",
|
|
"text" AS "name"
|
|
FROM text_data
|
|
WHERE category = 47
|
|
)
|
|
SELECT
|
|
group_id,
|
|
name
|
|
FROM skill_data d
|
|
JOIN skill_names n ON d.id = n.id
|
|
WHERE d.group_rate = 1
|
|
ORDER BY group_id
|