-- Collection of code snippets by Arne Vajhøj 
-- (likely posted to comp.os.vms/INFO-VAX, INFO-TPU, MACRO32, eksperten.dk, newz.dk, LinkedIn or other place sometime between 1990 and now) 
CREATE TABLE calendar (id INTEGER AUTO_INCREMENT PRIMARY KEY, dato DATE);

INSERT INTO calendar(dato) VALUES('2008-11-27');
INSERT INTO calendar(dato) VALUES('2008-11-27');
INSERT INTO calendar(dato) VALUES('2008-12-11');
INSERT INTO calendar(dato) VALUES('2008-12-06');
INSERT INTO calendar(dato) VALUES('2008-12-04');
INSERT INTO calendar(dato) VALUES('2008-12-13');
INSERT INTO calendar(dato) VALUES('2008-12-20');
INSERT INTO calendar(dato) VALUES('2008-12-18');
INSERT INTO calendar(dato) VALUES('2008-12-25');
INSERT INTO calendar(dato) VALUES('2008-12-26');
INSERT INTO calendar(dato) VALUES('2008-12-27');
INSERT INTO calendar(dato) VALUES('2008-12-31');

SELECT * FROM calendar;
SELECT COUNT(*) FROM calendar;
SELECT COUNT(DISTINCT dato) FROM calendar;

DROP TABLE calendar;
