Sobes.tech
Junior — Senior

SQL query to retrieve training directions with assigned teachers

livecode

Task condition

In the organization, there is a set of teachers and a set of courses they conduct. One teacher can work in multiple courses, and each course can involve several teachers. The instructors table has two columns: full_name and position, while the courses table has a single column: name. Some courses may not have teachers. Write an SQL query that returns all courses that have at least one teacher.