/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 vote141 views1 answer
Sql server python connection
SQL
4 votes133 views6 answers
List all tables in postgres
SQL
11 votes203 views1 answer
Oracle insert from select
SQL
15 votes139 views4 answers
Pl sql
SQL
2 votes133 views1 answer
No data found oracle
SQL
0 vote127 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
38 votes181 views6 answers
Alter table mysql
SQL
0 vote142 views1 answer
Postgre query date
SQL
0 vote158 views1 answer
SQL Where-Klausel
SQL
0 vote123 views1 answer
Commit transaction sql
SQL