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)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

--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


--CREATE TABLE CoolTable (
       SELECT Users.Id, Users.DisplayName, Posts.CommentCount, Users.CreationDate, Users.LastAccessDate, Users.Location, Comments.Score
       FROM Users
       JOIN Comments ON Users.Id = Comments.Id 
       JOIN Posts ON Users.Id = Posts.Id
       WHERE EXISTS (SELECT Users.DisplayName, Comments.Text  
               FROM Users
               JOIN Comments ON Users.Id = Comments.Id
                WHERE LEN(Comments.Text) > 150)
       ORDER BY Posts.CommentCount DESC
--);
       
--  a int,
--  b nvarchar (40),
--  c int,
--  d datetime,
--  e datetime,
--  f nvarchar (100),
--  g int
--)

--INSERT INTO CoolTable (
   
--)


--

Enter Parameters

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