5. Create a result set with the following format for posts that have 5 or more tags where tags is

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mythology Meta

Q&A about the site for enthusiasts and scholars of mythology and folklore

SELECT 
    REPLACE(Tags, ' ', ', ') AS Tags, 
    (LEN(Tags) - LEN(REPLACE(Tags, ' ', '')) + 1) AS NumberOfTags,
    Id AS PostId,
    OwnerUserId AS UserId,
    Body AS PostBody
FROM 
    Posts
WHERE 
    LEN(Tags) - LEN(REPLACE(Tags, ' ', '')) + 1 >= 5;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results