/SQL/Sql how to get courses that i have made prerequisites

Sql how to get courses that i have made prerequisites

SET @courses_completed = '2';
SELECT c.course_id
FROM course c
LEFT JOIN course_prerequisites p ON p.course_id = c.course_id
WHERE NOT FIND_IN_SET(c.course_id, @courses_completed)
GROUP BY c.course_id
HAVING SUM(COALESCE(FIND_IN_SET(p.prerequisite_course_id, @courses_completed), 0) > 0) = COUNT(p.prerequisite_course_id);

Source: stackoverflow.com

Similar codes

6 votes234 views4 answers
Remove spaces sql server
SQL
6 votes255 views2 answers
Oracle trigger
SQL
11 votes240 views5 answers
How to install sqlite3 python
SQL
10 votes239 views4 answers
Sql pagination
SQL
10 votes238 views1 answer
User_dependencies
SQL
0 vote223 views1 answer
Sql server update top n records
SQL
16 votes251 views1 answer
Mysql reset auto increment value
SQL
2 votes241 views5 answers
Eloquest how to select one specific column in database
SQL
7 votes188 views1 answer
Alter table add key sql
SQL
4 votes237 views2 answers
Postgres update single column
SQL