CREATE TABLE Jupiter_Neptune_Opposition (
    date VARCHAR(11) NOT NULL,
    time VARCHAR(8) NOT NULL,
    arc INT NOT NULL,
    jupiter VARCHAR(10) NOT NULL,
    neptune VARCHAR(10) NOT NULL
);

INSERT INTO Jupiter_Neptune_Opposition (date, time, arc, jupiter, neptune) VALUES
('JAN 07, 1901', '05:28 AM', 180, '27SA21', '27GE21R'),
('JAN 09, 1914', '06:06 AM', 180, '27CP05', '27CA05R'),
('APR 18, 1926', '04:12 AM', 180, '22AQ03', '22LE03R'),
('AUG 02, 1926', '09:46 AM', 180, '23AQ56R', '23LE56'),
('JAN 02, 1927', '09:38 PM', 180, '26AQ41', '26LE41R'),
('APR 02, 1939', '05:23 AM', 180, '21PI26', '21VI26R'),
('MAR 21, 1952', '05:12 PM', 180, '20AR52', '20LI52R'),
('JUN 18, 1964', '07:04 AM', 180, '15TA27', '15SC27R'),
('DEC 03, 1964', '03:52 PM', 180, '18TA26R', '18SC26'),
('FEB 28, 1965', '09:28 PM', 180, '19TA59', '19SC59R'),
('JUN 08, 1977', '08:49 PM', 180, '14GE41', '14SA41R'),
('OCT 01, 1989', '06:51 AM', 180, '09CA38', '09CP38'),
('NOV 14, 1989', '08:01 PM', 180, '10CA24R', '10CP24'),
('JUN 06, 1990', '09:05 AM', 180, '13CA56', '13CP56R'),
('SEP 11, 2002', '12:37 PM', 180, '08LE36', '08AQ36R'),
('FEB 16, 2003', '08:36 AM', 180, '11LE17R', '11AQ17'),
('JUN 03, 2003', '03:36 AM', 180, '13LE06', '13AQ06R'),
('SEP 17, 2015', '07:33 AM', 180, '07VI58', '07PI58R'),
('SEP 28, 2028', '08:05 PM', 180, '07LI31', '07AR31R'),
('OCT 12, 2041', '02:57 AM', 180, '07SC11', '07TA11R'),
('JAN 28, 2054', '07:30 AM', 180, '02SA22', '02GE22R'),
('MAY 03, 2054', '12:07 AM', 180, '03SA58R', '03GE58'),
('OCT 21, 2054', '08:34 PM', 180, '06SA55', '06GE55R'),
('JAN 28, 2067', '08:55 PM', 180, '01CP58', '01CA58R'),
('JUL 23, 2067', '10:52 AM', 180, '05CP01R', '05CA01'),
('OCT 17, 2067', '11:25 PM', 180, '06CP31', '06CA31R'),
('JAN 29, 2080', '03:10 AM', 180, '01AQ39', '01LE39R'),
('JAN 23, 2093', '07:25 AM', 180, '01PI17', '01VI17R');