Show each book's title, its tags array, and the number of tags (array_length), as tag_count. Order by id.
Show each book's title, its tags array, and the number of tags (array_length), as tag_count. Order by id.
Answer
SELECT title, tags, array_length(tags, 1) AS tag_count FROM books ORDER BY id;