/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

1 vote219 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
2 votes206 views1 answer
No data found oracle
SQL
0 vote219 views3 answers
Database restoring error
SQL
0 vote204 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
3 votes231 views2 answers
Mysql select database
SQL
0 vote230 views1 answer
Oracle sql all days except weekends
SQL
0 vote203 views1 answer
How to update random rows in sql
SQL
6 votes214 views4 answers
Remove spaces sql server
SQL
0 vote213 views1 answer
Mysql add to value
SQL
2 votes218 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL