fork download
  1. CREATE TABLE Students (name varchar(10), direction varchar(20), course DOUBLE, practice varchar(40));
  2. SELECT * FROM Students;
  3. INSERT INTO Students VALUES
  4. ('Marat', 'IS', 2, 'web'),
  5. ('Adam', 'VT', 2, 'sysadmin'),
  6. ('Sam', 'IS', 1, 'backend'),
  7. ('Marat', 'IS', 1, 'frontend'),
  8. ('Simon', 'VT', 2, 'sysadmin'),
  9. ('Marat', 'VT', 1, 'frontend');
  10. SELECT * FROM Students;
  11.  
  12.  
  13. CREATE TABLE Prac (direction varchar(10), course DOUBLE, practice varchar(20), company varchar(30));
  14. SELECT * FROM Prac;
  15. INSERT INTO Prac VALUES
  16. ('IS', 2, 'web', 'bank'),
  17. ('VT', 2, 'sysadmin', 'tech company'),
  18. ('IS', 1, 'backend', 'tech company'),
  19. ('IS', 1, 'frontend', 'tech company'),
  20. ('VT', 3, 'sysadmin', 'bank'),
  21. ('VT', 1, 'bak', 'frontend');
  22. SELECT * FROM Prac;
  23.  
Success #stdin #stdout 0.01s 5304KB
stdin
Standard input is empty
stdout
Marat|IS|2.0|web
Adam|VT|2.0|sysadmin
Sam|IS|1.0|backend
Marat|IS|1.0|frontend
Simon|VT|2.0|sysadmin
Marat|VT|1.0|frontend
IS|2.0|web|bank
VT|2.0|sysadmin|tech company
IS|1.0|backend|tech company
IS|1.0|frontend|tech company
VT|3.0|sysadmin|bank
VT|1.0|bak|frontend