/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

20 votes109 views3 answers
Update values in select statement sql
SQL
0 vote109 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote106 views1 answer
Exec procedure oracle
SQL
1 vote112 views1 answer
Sql server list locks
SQL
6 votes98 views2 answers
How to get yesterday date in mysql
SQL
0 vote108 views1 answer
Top 3 salary in sql
SQL
3 votes115 views6 answers
DB::table('users')->get();
SQL
1 vote114 views1 answer
Oracle stop
SQL
1 vote93 views1 answer
Sql restore backup query
SQL
16 votes102 views2 answers
Add column to all tables after first column mysql
SQL