Show all websites which were hosted in the first half of the month

CREATE TABLE mytr (url_id int, url_addr varchar(100), host_date date);

INSERT INTO mytr VALUES (1, 'www.google.com', '2012-10-01');

INSERT INTO mytr VALUES (2, 'www.microsoft.com', '2012-10-12');

INSERT INTO mytr VALUES (3, 'www.apple.com', '2012-10-17');

INSERT INTO mytr VALUES (4, 'www.google.com', '2012-10-11');

INSERT INTO mytr VALUES (5, 'www.cnn.com', '2012-10-21');

INSERT INTO mytr VALUES (6, 'www.apple.com', '2012-10-30');

SELECT * FROM mytr

WHERE host_date

BETWEEN '2012-10-01' AND '2012-10-15'