Find the names of all students who have taken at least one Comp. Sci. course; make sure there are no

Find the names of all students who have taken at least one Computer Science (Comp. Sci.) course; ensure that the list is complete and excludes any duplicates. To accomplish this task, you would typically query a database or access a student record system where courses and students are stored. You'd look for a table containing students and their corresponding enrolled courses, then filter by the 'Computer Science' department.

Here's a possible SQL query to retrieve such information:

SELECT DISTINCT student_name
FROM students
JOIN enrollments ON students.student_id = enrollments.student_id
JOIN courses ON enrollments.course_id = courses.course_id
WHERE courses.department = 'Comp. Sci.';

This query joins three tables (students, enrollments, and courses) based on common IDs and filters for the 'Comp. Sci.' department. The `DISTINCT` keyword ensures no duplicate student names are included in the result.