Загрузка данных


6
SELECT CONCAT(Surname, ' ', LEFT(Name, 1), '.') AS Student_Name
FROM Student 
WHERE Surname LIKE 'а%в%' OR Surname LIKE 'А%в%';
7
SELECT Surname, tel FROM Student WHERE tel REGEXP '^[2-57]+$';
8
SELECT Surname FROM Student WHERE Address LIKE '%д. 78%';
9
SELECT * FROM Student WHERE Surname IN ('Иванов', 'Петров', 'Сидоров');
10
SELECT Surname FROM Student 
WHERE Surname BETWEEN 'Иванов' AND 'Сидоров' 
ORDER BY Surname;
11
SELECT DISTINCT s.Surname 
FROM Student s 
JOIN Marks m ON s.Student_idStudent = m.Student_idStudent 
WHERE m.Subject = 'Математика' AND m.Mark >= 3;
12
SELECT DISTINCT Mark, Mark * 20 AS Mark_100 
FROM Marks;