Tell me Julio's address.
select address_line_1 from course_authors_and_tutors where personal_name = "Julio"
Tell me the number of courses that he teaches.
select count(t2.course_name) from course_authors_and_tutors as t1 join courses as t2 on t1.author_id = t2.author_id where t1.personal_name = "Julio"
What are they?
select t2.course_name from course_authors_and_tutors as t1 join courses as t2 on t1.author_id = t2.author_id where t1.personal_name = "Julio"