SQl_QUEST_2_PRESENTATION_IMG_COUNT, Sql Server

Language: Layout:

CREATE TABLE EVENT_LOGS
(
    UserId INT,
    [TimeStamp] DATETIME    
)
GO

INSERT INTO EVENT_LOGS VALUES (1, GETDATE());
INSERT INTO EVENT_LOGS VALUES (2, GETDATE());
INSERT INTO EVENT_LOGS VALUES (5, GETDATE());
INSERT INTO EVENT_LOGS VALUES (1, GETDATE());
INSERT INTO EVENT_LOGS VALUES (3, GETDATE());
INSERT INTO EVENT_LOGS VALUES (2, GETDATE());
INSERT INTO EVENT_LOGS VALUES (1, GETDATE());
INSERT INTO EVENT_LOGS VALUES (4, GETDATE());
INSERT INTO EVENT_LOGS VALUES (1, GETDATE());
INSERT INTO EVENT_LOGS VALUES (1, GETDATE());
INSERT INTO EVENT_LOGS VALUES (2, GETDATE());
INSERT INTO EVENT_LOGS VALUES (5, GETDATE());
INSERT INTO EVENT_LOGS VALUES (1, GETDATE());
INSERT INTO EVENT_LOGS VALUES (3, GETDATE());
INSERT INTO EVENT_LOGS VALUES (2, GETDATE());
INSERT INTO EVENT_LOGS VALUES (1, GETDATE());
INSERT INTO EVENT_LOGS VALUES (4, GETDATE());
INSERT INTO EVENT_LOGS VALUES (1, GETDATE());
INSERT INTO EVENT_LOGS VALUES (1, GETDATE());
INSERT INTO EVENT_LOGS VALUES (2, GETDATE());
INSERT INTO EVENT_LOGS VALUES (5, GETDATE());
INSERT INTO EVENT_LOGS VALUES (1, GETDATE());
INSERT INTO EVENT_LOGS VALUES (3, GETDATE());
INSERT INTO EVENT_LOGS VALUES (2, GETDATE());
INSERT INTO EVENT_LOGS VALUES (1, GETDATE());
INSERT INTO EVENT_LOGS VALUES (4, GETDATE());
INSERT INTO EVENT_LOGS VALUES (1, GETDATE());
INSERT INTO EVENT_LOGS VALUES (1, GETDATE());
INSERT INTO EVENT_LOGS VALUES (2, GETDATE());
INSERT INTO EVENT_LOGS VALUES (5, GETDATE());
INSERT INTO EVENT_LOGS VALUES (1, GETDATE());
INSERT INTO EVENT_LOGS VALUES (3, GETDATE());
INSERT INTO EVENT_LOGS VALUES (2, GETDATE());
INSERT INTO EVENT_LOGS VALUES (2, GETDATE());
INSERT INTO EVENT_LOGS VALUES (2, GETDATE());
INSERT INTO EVENT_LOGS VALUES (1, GETDATE());
INSERT INTO EVENT_LOGS VALUES (4, GETDATE());
INSERT INTO EVENT_LOGS VALUES (1, GETDATE());
Go

SELECT UserId, COUNT(UserId) AS IMAGE_COUNT
FROM EVENT_LOGS
GROUP BY UserId
HAVING COUNT(UserId) BETWEEN 10 AND 20

View schema
Execution time: 0,02 sec, rows selected: 2, rows affected: 38, absolute service time: 0,17 sec, absolute service time: 0,16 sec