Is there some way to write this query in SQLite?
UPDATE
groups
SET
(fileCount, size) = (SELECT count(id), sum(size) FROM files where groupId =
15)
WHERE
groupId = 15;Or must it be written like this?
UPDATE
groups
SET
fileCount = (SELECT count(id) FROM files where groupId = 15),
size = (SELECT sum(size) FROM files where groupId = 15)
WHERE
groupId = 15;I mostly want to get the two selects into one and I can't place code between the two.

