/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 vote144 views1 answer
Oracle index hint
SQL
0 vote143 views1 answer
Oracle list dblink
SQL
2 votes145 views1 answer
Possgress drop if exists table
SQL
0 vote154 views1 answer
Alter rename command in mysql
SQL
4 votes176 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote162 views1 answer
Define a variable in mysql from select
SQL
0 vote149 views1 answer
Flask sqlalchemy remove duplicates
SQL
0 vote153 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote112 views1 answer
Oracle sql replace string in clob
SQL
0 vote142 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL