/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 vote221 views1 answer
Composit key in sql
SQL
10 votes184 views2 answers
Oracle alter sequence nextval
SQL
0 vote176 views1 answer
Exec procedure oracle
SQL
37 votes180 views3 answers
Postgresql insert column
SQL
2 votes177 views1 answer
Oracle drop table free up space
SQL
2 votes193 views1 answer
Where clause for child record apex
SQL
7 votes162 views1 answer
Forge server hosting
SQL
0 vote157 views2 answers
Postgresql display subquery as json
SQL
0 vote231 views1 answer
Oracle running queries
SQL
6 votes179 views2 answers
Postgresql restore from dump
SQL