-- Table for FedEx Cup points distribution based on finishing position in tournaments
CREATE TABLE fedex_points (
    position INT PRIMARY KEY,
    points INT NOT NULL
);

-- Insert FedEx Cup points distribution for the top 30 positions
INSERT INTO fedex_points (position, points) VALUES
(1, 300),
(2, 290),
(3, 280),
(4, 270),
(5, 260),
(6, 250),
(7, 240),
(8, 230),
(9, 220),
(10, 210),
(11, 202),
(12, 194),
(13, 186),
(14, 178),
(15, 170),
(16, 162),
(17, 154),
(18, 146),
(19, 138),
(20, 130),
(21, 124),
(22, 118),
(23, 112),
(24, 106),
(25, 100),
(26, 94),
(27, 88),
(28, 82),
(29, 76),
(30, 70),
(31, 66),
(32, 62),
(33, 58),
(34, 54),
(35, 50),
(36, 46),
(37, 42),
(38, 38),
(39, 34),
(40, 30),
(41, 28),
(42, 26),
(43, 24),
(44, 22),
(45, 20),
(46, 18),
(47, 16),
(48, 14),
(49, 12),
(50, 10),
(51, 8),
(52, 6),
(53, 4),
(54, 2);