SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
-- create a table CREATE TABLE students ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, legitimation INTEGER NOT NULL, school TEXT NOT NULL ); CREATE TABLE exam ( id INTEGER PRIMARY KEY, student_num INTEGER NOT NULL, lang TEXT NOT NULL, score INTEGER NOT NULL ); INSERT INTO students VALUES (1, 'Ryan',1234,'Warsaw University'); INSERT INTO students VALUES (2, 'Arek',5555,'UEK'); INSERT INTO students VALUES (3, 'Daria', 2137,'UJ'); INSERT INTO students VALUES (4, 'Bodzio',3131,'AGH'); INSERT INTO students VALUES (5, 'Andrzej',7777,'UEK'); INSERT INTO students VALUES (6, 'Mariola', 8373,'UJ'); INSERT INTO students VALUES (7, 'Jaro', 4281,'AGH'); INSERT INTO students VALUES (8, 'Morda', 1111,'UJ'); INSERT INTO exam VALUES (1,1234, 'English', 86); INSERT INTO exam VALUES (2,5555, 'French', 77); INSERT INTO exam VALUES (3,2137, 'English', 99); INSERT INTO exam VALUES (4,3131, 'French', 54); INSERT INTO exam VALUES (5,7777, 'French', 66); INSERT INTO exam VALUES (6,8373, 'English', 86); INSERT INTO exam VALUES (7,8373, 'French', 70); INSERT INTO exam VALUES (8,4281, 'English', 90); INSERT INTO exam VALUES (9,4281, 'French', 83); INSERT INTO exam VALUES (10,1111, 'French', 90); INSERT INTO exam VALUES (11,1111, 'English', 80); select *, row_number(), from exam
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear