/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

0 vote151 views1 answer
Sql counter column
SQL
0 vote161 views1 answer
Normalization in database
SQL
0 vote165 views1 answer
Sql server roles and users
SQL
2 votes160 views2 answers
Sqlite_busy: database is locked
SQL
0 vote152 views1 answer
Sql max min
SQL
0 vote150 views1 answer
Datetime postgres typeorm
SQL
0 vote148 views1 answer
Top frequency in sql server
SQL
0 vote178 views1 answer
Sql developer sql worksheet not showing
SQL
11 votes145 views2 answers
Oracle all source
SQL
3 votes164 views2 answers
Sqlite print all column names
SQL