CREATE TABLE The_Blue_Moon(
    Date VARCHAR(12),   
    Time VARCHAR(8),     
    Lunation VARCHAR(9), 
    Zodiac VARCHAR(6),   
    Notes VARCHAR(5)     
);

INSERT INTO The_Blue_Moon (Date, Time, Lunation, Zodiac, Notes) VALUES
('JUL 31, 1901', '10:34 AM', 'FULL MOON', '07AQ30', ''),
('MAR 31, 1904', '12:44 PM', 'FULL MOON', '10LI23', 'EA'),
('NOV 30, 1906', '11:07 PM', 'FULL MOON', '07GE51', ''),
('AUG 31, 1909', '05:08 AM', 'FULL MOON', '07PI08', 'P'),
('MAY 30, 1912', '11:29 PM', 'FULL MOON', '09SA08', ''),
('JAN 31, 1915', '04:41 AM', 'FULL MOON', '10LE14', 'EA'),
('MAR 31, 1915', '05:37 AM', 'FULL MOON', '09LI26', ''),
('SEP 30, 1917', '08:31 PM', 'FULL MOON', '07AR06', 'P'),
('JUL 30, 1920', '11:19 PM', 'FULL MOON', '07AQ26', ''),
('APR 30, 1923', '09:30 PM', 'FULL MOON', '09SC30', 'P'),
('OCT 31, 1925', '05:17 PM', 'FULL MOON', '07TA46', ''),
('AUG 31, 1928', '02:34 AM', 'FULL MOON', '07PI26', ''),
('MAY 31, 1931', '02:33 PM', 'FULL MOON', '09SA10', ''),
('DEC 31, 1933', '08:54 PM', 'FULL MOON', '09CA46', ''),
('MAR 31, 1934', '01:14 AM', 'FULL MOON', '09LI39', ''),
('SEP 30, 1936', '09:01 PM', 'FULL MOON', '07AR30', 'P'),
('JUL 31, 1939', '06:37 AM', 'FULL MOON', '07AQ10', ''),
('APR 30, 1942', '10:00 PM', 'FULL MOON', '09SC54', ''),
('OCT 31, 1944', '01:36 PM', 'FULL MOON', '08TA01', ''),
('AUG 31, 1947', '04:34 PM', 'FULL MOON', '07PI25', ''),
('MAY 31, 1950', '12:43 PM', 'FULL MOON', '09SA29', 'P'),
('DEC 31, 1952', '05:06 AM', 'FULL MOON', '09CA29', ''),
('OCT 31, 1955', '06:05 AM', 'FULL MOON', '07TA02', ''),
('JUL 30, 1958', '04:48 PM', 'FULL MOON', '07AQ00', ''),
('JAN 31, 1961', '06:47 PM', 'FULL MOON', '11LE41', ''),
('APR 30, 1961', '06:41 PM', 'FULL MOON', '10SC10', ''),
('NOV 30, 1963', '11:54 PM', 'FULL MOON', '08GE03', 'P'),
('AUG 31, 1966', '00:13 AM', 'FULL MOON', '07PI09', ''),
('MAY 31, 1969', '01:18 PM', 'FULL MOON', '09SA54', 'P'),
('DEC 31, 1971', '08:20 PM', 'FULL MOON', '09CA30', ''),
('OCT 31, 1974', '01:19 AM', 'FULL MOON', '07TA14', ''),
('JUL 30, 1977', '10:53 AM', 'FULL MOON', '07AQ09', ''),
('MAR 31, 1980', '03:15 PM', 'FULL MOON', '11LI04', ''),
('DEC 30, 1982', '11:34 AM', 'FULL MOON', '08CA27', 'ET P'),
('JUL 31, 1985', '09:41 PM', 'FULL MOON', '08AQ36', ''),
('MAY 31, 1988', '10:53 AM', 'FULL MOON', '10SA12', ''),
('DEC 31, 1990', '06:36 PM', 'FULL MOON', '09CA49', 'P'),
('SEP 30, 1993', '06:54 PM', 'FULL MOON', '07AR37', ''),
('JUL 30, 1996', '10:36 AM', 'FULL MOON', '07AQ32', 'P'),
('JAN 31, 1999', '04:07 PM', 'FULL MOON', '11LE20', 'EA'),
('MAR 31, 1999', '10:50 PM', 'FULL MOON', '10LI46', '');