I've been trying to find this on the data explorer, but no luck. I need some help to write a query identical to the one found on our profile pages that displays tag information. The query would have to return:
- Each tag used by the user
- The number of times this tag has been used.
- The number of points gained for answers given to questions that use this tag.
I wrote the following so far on data-explorer to get the tags and to the tag count:
SELECT COUNT(tags.tagName), tags.tagName FROM postTags LEFT JOIN tags ON postTags.tagId = tags.id LEFT JOIN posts ON postTags.postId = posts.id WHERE posts.ownerUserId = 3 GROUP BY tags.tagName
But I'm not sure how to get the score count per answer, or item 3 in my list!
Any help would appreciated!