create_q3.sql

CREATE TABLE UserTable(UserName varchar(5), UserDate DATETIME, url int);
INSERT INTO UserTable (UserName, UserDate, url)
VALUES
('user1', '2014-09-01', 232),
('user1', '2014-09-02', 0), ('user1', '2014-09-03', 121), ('user1', '2014-09-08', 122), ('user1', '2014-09-09', 0), ('user1', '2014-09-10', 144), ('user1', '2014-09-11', 166), ('user2', '2014-09-01', 177), ('user2', '2014-09-04', 188), ('user2', '2014-09-05', 199), ('user2', '2014-09-06', 0), ('user2', '2014-09-07', 155), ('user3', '2014-09-03', 56), ('user3', '2014-09-04', 789), ('user3', '2014-09-07', 234), ('user3', '2014-09-09', 123);