LISTING A: Code to Create a Table Containing Web Site Data

CREATE TABLE web_hits (
  site_url varchar(255) NOT NULL,
  caller_ip varchar(15) NOT NULL,
  hit_datetime datetime NOT NULL )

INSERT web_hits (site_url, caller_ip, hit_datetime)
VALUES ('we-make-flags.com', '207.241.80.174', '2001-07-04 07:30:05.323')
INSERT web_hits (site_url, caller_ip, hit_datetime)
VALUES ('we-make-flags.com', '207.241.80.174', '2001-07-04 07:31:44.120')
INSERT web_hits (site_url, caller_ip, hit_datetime)
VALUES ('we-make-flags.com', '207.241.80.174', '2001-07-04 07:33:19.983')
INSERT web_hits (site_url, caller_ip, hit_datetime)
VALUES ('we-make-flags.com', '207.241.80.174', '2001-07-04 08:02:14.330')
INSERT web_hits (site_url, caller_ip, hit_datetime)
VALUES ('we-make-flags.com', '207.241.80.174', '2001-07-04 14:01:09.220')
INSERT web_hits (site_url, caller_ip, hit_datetime)
VALUES ('we-make-flags.com', '207.241.80.174', '2001-07-04 14:25:21.787')

site_url            caller_ip        hit_datetime
------------------------------------------------------------
we-make-flags.com   207.241.80.174   2001-07-04 07:30:05.323
we-make-flags.com   207.241.80.174   2001-07-04 07:31:44.120
we-make-flags.com   207.241.80.174   2001-07-04 07:33:19.983
we-make-flags.com   207.241.80.174   2001-07-04 08:02:14.330
we-make-flags.com   207.241.80.174   2001-07-04 14:01:09.220
we-make-flags.com   207.241.80.174   2001-07-04 14:25:21.787