Please take the following tables: Users, Comments, and Posts, create a new table with the informatio

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts Meta

Q&A about the site for enthusiasts and power users of the Android operating system

--SELECT SUBSTRING(Text, 1, CHARINDEX('.', Text))
--FROM Comments
--JOIN Posts ON Comments.Id = Posts.Id
--WHERE  CommentCount   > 2

--SELECT * FROM Users 
--JOIN Comments ON Users.Id = Comments.Id 
--WHERE UserDisplayName = ('MichelleObama')

--INSERT INTO Users  DEFAULT VALUES

SELECT Users.DisplayName  FROM Users
--JOIN Comments ON Id.Users = Id.Comments
--WHERE LEN(PostHistory.Comment) > 150

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results