INSERT INTO operations(`type`,  `reason_id`,    `sum`,  notes,  for_date,   `user_id`) VALUES
('O',   (SELECT id FROM reasons WHERE name='Coffee'),   '2.50', 'Costa',    STR_TO_DATE('10/4/2017', '%m/%d/%Y'),   (SELECT id FROM users WHERE username='peter')),
('I',   (SELECT id FROM reasons WHERE name='Salary'),   '500.00', '',   STR_TO_DATE('7/3/2017', '%m/%d/%Y'),    (SELECT id FROM users WHERE username='Alice')),
('O',   (SELECT id FROM reasons WHERE name='Party'), '120.09',  'Club', STR_TO_DATE('11/6/2017', '%m/%d/%Y'),   (SELECT id FROM users WHERE username='Alice')),
('O',   (SELECT id FROM reasons WHERE name='Coffee'),   '0.90', 'Game Bar', STR_TO_DATE('9/17/2017', '%m/%d/%Y'),   (SELECT id FROM users WHERE username='Alice'));