CREATE TABLE taxesPayment(
id int auto_increment primary key,
student_id int not null,
group_id int not null,
paymentAmount double not null,
month int,
year int,
dateOfPayment datetime not null,
constraint foreign key (student_id) references students(id),
constraint foreign key (group_id) references sportgroups(id)
);
INSERT INTO taxesPayment (student_id, group_id, paymentAmount, month, year, dateOfPayment)
VALUES
(1,11, 200, 3, 2022, now()),
(1,30, 200, 4, 2022, now()),
(1,33, 200, 5, 2022, now()),
(1,11, 200, 6, 2022, now()),
(1,11, 200, 7, 2022, now()),
(1,11, 200, 8, 2022, now()),
(1,30, 200, 9, 2022, now()),
(1,33, 200, 10, 2022, now()),
(1,33, 200, 11, 2022, now()),
(1,33, 200, 12, 2022, now()),
(4,11, 200, 1, 2022, now()),
(4,49, 200, 2, 2022, now()),
(4,49, 200, 3, 2022, now()),
(4,49, 200, 4, 2022, now()),
(4,49, 200, 5, 2022, now()),
(4,11, 200, 6, 2022, now());