CREATE TABLE test_tbl ( u_name varchar NOT NULL, u_color varchar NULL ); INSERT INTO test_tbl (u_name, u_color) values ('Ivanov', 'RED'); INSERT INTO test_tbl (u_name, u_color) values ('Petrov', 'YELLOW'); INSERT INTO test_tbl (u_name, u_color) values ('Ivanov', 'RED'); INSERT INTO test_tbl (u_name, u_color) values ('Petrov', 'YELLOW'); INSERT INTO test_tbl (u_name, u_color) values ('Ivanov', 'GREEN'); INSERT INTO test_tbl (u_name, u_color) values ('Petrov', 'PERFECT'); INSERT INTO test_tbl (u_name, u_color) values ('Petrov', 'RED'); INSERT INTO test_tbl (u_name, u_color) values ('Sidorov', 'GREEN'); INSERT INTO test_tbl (u_name, u_color) values ('Sidorov', 'GREEN'); INSERT INTO test_tbl (u_name, u_color) values ('Sidorov', 'YELLOW'); INSERT INTO test_tbl (u_name, u_color) values ('Ivanov', 'RED'); INSERT INTO test_tbl (u_name, u_color) values ('Sidorov', 'PERFECT'); INSERT INTO test_tbl (u_name, u_color) values ('Sidorov', 'PERFECT'); INSERT INTO test_tbl (u_name, u_color) values ('Petrov', 'YELLOW'); INSERT INTO test_tbl (u_name, u_color) values ('Ivanov', 'GREEN'); INSERT INTO test_tbl (u_name, u_color) values ('Sidorov', 'RED'); INSERT INTO test_tbl (u_name, u_color) values ('Petrov', 'RED'); INSERT INTO test_tbl (u_name, u_color) values ('Petrov', 'GREEN'); INSERT INTO test_tbl (u_name, u_color) values ('Ivanov', 'YELLOW'); INSERT INTO test_tbl (u_name, u_color) values ('Sidorov', 'RED'); |