I have three Tables:

CREATE TABLE IF NOT EXISTS countable(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS collection(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS count(
    countableId INTEGER NOT NULL,
    collectionId INTEGER NOT NULL,
    count INTEGER NOT NULL
);

My plan is to be able to select two collections (For example collection.id = 3 OR collection.id = 4) and get two counts per countable. This already works:

+-----------+------------+-------+
| countable | collection | count |
+-----------+------------+-------+
| Example   | Col 3      | 0     |
| Example   | Col 4      | 5     |
| Test      | Col 3      | 1     |
| Test      | Col 4      | 0     |
| Foo       | Col 3      | 0     |
| Foo       | Col 4      | 0     |
| Bar       | Col 3      | 5     |
| Bar       | Col 4      | 3     |
+-----------+------------+-------+

However, I want a table where there are no duplicate coutables, something like this:

+-----------+--------------+----------------+
| countable | primaryCount | secondaryCount |
+-----------+--------------+----------------+
| Example   | 0            | 5              |
| Test      | 1            | 0              |
| Foo       | 0            | 0              |
| Bar       | 5            | 3              |
+-----------+--------------+----------------+

I tried using grouping, which sort of works:

SELECT
countable.name AS countable,
count AS primaryCount,      <--- This is the Problem
count AS secondaryCount     <--- This is the Problem
FROM count
JOIN countable ON countable.id = count.countableId
JOIN collection ON collection.id = count.collectionId
WHERE collection.id = 3 OR collection.id = 4
GROUP BY countable.id
;

But this just returns the primatyCount both times:

+-----------+--------------+----------------+
| countable | primaryCount | secondaryCount |
+-----------+--------------+----------------+
| Example   | 0            | 0              |
| Test      | 1            | 1              |
| Foo       | 0            | 0              |
| Bar       | 5            | 5              |
+-----------+--------------+----------------+

I also tried group_concat like this:

SELECT
countable.name AS countable,
group_concat(count)
FROM count
JOIN countable ON countable.id = count.countableId
JOIN collection ON collection.id = count.collectionId
WHERE collection.id = 3 OR collection.id = 4
GROUP BY countable.id
;

This returns:

+-----------+---------------------+
| countable | group_concat(count) |
+-----------+---------------------+
| Example   | 0,5                 |
| Test      | 1,0                 |
| Foo       | 0,0                 |
| Bar       | 5,3                 |
+-----------+---------------------+

which works, however I would have to split the values in code, which is not really ideal I guess. Is there some syntax like count[0] and count[1] or other solutions to do this cleanly in SQLite?