· 7 years ago · Sep 15, 2018, 07:38 AM
1https://www.db-fiddle.com/ https://www.db-fiddle.com/ https://www.db-fiddle.com/ https://www.db-fiddle.com/
2
3
4CREATE TABLE IF NOT EXISTS Students (
5id int PRIMARY KEY,
6Surname varchar(50),
7Name varchar(50),
8MiddleName varchar(50),
9Groups int,
10DateOfBrith date,
11Speciality varchar(50));
12INSERT INTO Students (id, Surname, Name, MiddleName, Groups, DateOfBrith, Speciality)
13VALUES("1", "Zubenko", "Mihail", "Petrovitch", "1337", "2000_01_01", "Mafioznik"),
14 ("2", "Sedyh", "Anton", 'Sesovich', 1488, "2001_09_12", "Bashylbek"),
15 ("3", "Chupenco", "Dmitry", "galikberovich", 1487, "1999_03_08", "Sesanok"),
16 ("4", "Zjmyshenko", "Valeryi", "Albertovich", 322, "1987_01_05", "Bomj"),
17 ("5", "Peplixov", "Memblex", "Petrosovich", 228, "1994_05_12", "loh"),
18 ("6", "Peplixova", "Marina","sovieh", 228, "1994_05_12", "loh")
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
341 SELECT * FROM Students
35
362 SELECT * FROM Students
37 WHERE name = "Marina"
383 SELECT * FROM Students
39 WHERE Groups = 397
404 SELECT * FROM Students
41 WHERE Groups = "397" and Name = "Alexandr"
425 SELECT * FROM Students
43 WHERE DateOfBrith between "2000_01_01" and "2001_01_01"
446 SELECT Surname FROM Students
45 WHERE DateOfBrith < "1998_01_01" and Speciality = "Zashita informacii" or Speciality = "Komputernie systemi"
46 ORDER BY Surname
477 SELECT Speciality FROM Students
48 WHERE Surname like "p_%"
49
50
51
52
53CREATE TABLE IF NOT EXISTS BookShop (
54id int PRIMARY KEY,
55BookName varchar(50),
56BookAuthor varchar(50),
57Country varchar(50),
58DateOfPublication date,
59Price int,
60BookGenre varchar(50));
61
62
63
64
65
66INSERT INTO BookShop (id, BookName, BookAuthor, Country, DateOfPublication, Price, BookGenre)
67VALUES("1", "A Doll's House", "Henrik Ibsen", "Norway", "1906_02_01", 1489, "Jop"),
68 ("2", "A Sentimental Education", "Gustave Flaubert", "France", "1880_09_05", 889, "sas"),
69 ("3", "The Adventures of Huckleberry Finn", "Mark Twain", "United States", "1910_07_06", 231, "haah"),
70 ("4", "Beloved", "Toni Morrison", "United States", "1931_08_04", 2231, "sas"),
71 ("5", "Blindness", "Jose Saramago", "Portugal", "1922_01_04", 23113, "Jop") ,
72 ("7", "Complete Poems", "Giacomo Leopardi", "Italy", "1837_09_04", 6547, "sas") ,
73 ("8", "Crime and Punishment", " Fyodor M Dostoyevsky", "Russia", "1881_06_04", 956, "haah") ,
74 ("9", "Decameron", "Giovanni Boccaccio", "Italy", "1313_01_04", 1223, "sas") ,
75 ("10", "Faust", "Johann Wolfgang", "Germany", "1749_05_05", 878, "haah");
76
77
78
79
80
81
82
831 SELECT * FROM BookShop
842 SELECT * FROM BookShop
85 WHERE BookName = "Beloved"
863 SELECT * FROM BookShop
87 WHERE BookGenre = "sas"
884 SELECT * FROM BookShop
89 WHERE BookGenre = "sas" and Country = "Italy"