query 1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

SELECT TOP 5
    question.Id, question.Title, question.CreationDate, 
    question.Score, question.ViewCount, question.AnswerCount, 
    question.CommentCount, usr.Id AS UserId, 
    usr.Reputation, usr.DisplayName
FROM Posts question
    INNER JOIN Users usr ON question.OwnerUserId = usr.Id
WHERE
    question.PostTypeId = 1
    AND LOWER(question.Title) LIKE '%big data%'
    AND LOWER(question.Title) LIKE '%test%'
ORDER BY question.CreationDate DESC;

Enter Parameters

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