Can you please provide the names of all courses?
select course_name from courses
Can you please provide the author id for the author that teaches the Advanced Database course?
select author_id from courses where course_name = "advanced database"
And what is the full name of the teacher with author id 6?
select personal_name, middle_name, family_name from course_authors_and_tutors where author_id = 6
And the login name for Adolf Keira Rohan?
select login_name from course_authors_and_tutors where personal_name like "%adolf%" and middle_name like "%keira%" and family_name like "%rohan%"