INSERT INTO GROUPS(groupname)
VALUES ('Grupa de bossi');
INSERT INTO GROUPS(groupname)
VALUES ('Grupa de fraeri');

INSERT INTO STUDENTS(username, password, fullname, username_ia, username_pbinfo, username_timus, username_codeforces)
VALUES ('andrei', 'parola', 'Andrei Popovici', 'warrior98', '', '199116WF', 'warrior98');
INSERT INTO STUDENTS(username, password, fullname, username_ia, username_pbinfo, username_timus, username_codeforces, groupname)
VALUES ('gicu', 'parola2', 'Gicu Gicu', 'gicu_infoarena', 'gicu_pbinfo', 'gicu_timus', 'gicu_codeforces', 'Grupa de fraeri');

INSERT INTO PROBLEMS(id_problema, site)
VALUES ('base3', 'infoarena');
INSERT INTO PROBLEMS(id_problema, site)
VALUES ('1040B', 'codeforces');
INSERT INTO PROBLEMS(id_problema, site)
VALUES ('1513', 'timus');

INSERT INTO SOLVED(FK_username, FK_id_problema)
VALUES ('andrei', 'base3');
INSERT INTO SOLVED(FK_username, FK_id_problema)
VALUES ('gicu', '1040B');

UPDATE SOLVED
SET FK_username = 'gicu'
WHERE FK_username = 'andrei' AND FK_id_problema = 'base3';

DELETE FROM STUDENTS
WHERE groupname IS NULL;

SELECT * FROM STUDENTS;
SELECT * FROM GROUPS;
SELECT * FROM SOLVED;
SELECT * FROM PROBLEMS;
SELECT * FROM SCHEDULE;