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;