/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 vote193 views1 answer
Mariadb get column names from table
SQL
0 vote192 views1 answer
Login failed for login due to trigger execution
SQL
14 votes245 views3 answers
Inner join sql oracle
SQL
0 vote234 views2 answers
Clauses in mysql
SQL
0 vote192 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote215 views1 answer
Drop index in sql
SQL
0 vote210 views1 answer
Sum sqlserver
SQL
0 vote195 views1 answer
ORA-13717
SQL
0 vote193 views1 answer
Hive batch drop table
SQL
4 votes207 views3 answers
Count with where
SQL