Insert

INSERT INTO `deposit_types`
VALUES
(1, 'Time Deposit'),
(2, 'Call Deposit'),
(3, 'Free Deposit');

INSERT INTO `deposits`(`amount`,
                        `start_date`,
                        `end_date`,
                        `deposit_type_id`,
                        `customer_id`)
SELECT
    (CASE
        WHEN c.date_of_birth > '1980-01-01' THEN 1000
    ELSE 1500
    END
    +
    CASE
        WHEN c.gender = 'M' THEN 100
        ELSE 200
        END) AS 'amount',
    DATE(NOW()) AS 'start_date',
    NULL AS 'end_date',
    (CASE
        WHEN c.customer_id > 15 THEN 3
        WHEN c.customer_id % 2 = 0 THEN 2
        ELSE 1
    END) AS 'deposit_type_id',
    c.customer_id AS 'customer_id'
FROM `customers` AS c
WHERE c.customer_id < 20;

INSERT INTO `employees_deposits`
VALUES
(15, 4),
(20, 15),
(8, 7),
(4, 8),
(3, 13),
(3, 8),
(4, 10),
(10, 1),
(13, 4),
(14, 9);