/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 vote115 views1 answer
Mysql root permission denied lost
SQL
4 votes104 views1 answer
What are the data types in sql
SQL
1 vote115 views1 answer
Oracle sql create or replace view
SQL
0 vote123 views1 answer
Pl/pgsql declare variable
SQL
13 votes125 views3 answers
Change data type postgresql
SQL
0 vote110 views1 answer
Mysql identified by syntax error
SQL
23 votes112 views6 answers
How to create table in sql
SQL
0 vote119 views1 answer
Mysql cast null to string
SQL
1 vote195 views1 answer
Athena query timestamp greater than
SQL
2 votes106 views2 answers
Function in sql
SQL