/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 vote299 views1 answer
Big query add table rows to another table
SQL
2 votes345 views1 answer
Mysql change data type of column
SQL
1 vote329 views1 answer
Oracle user last connected
SQL
0 vote341 views4 answers
Mysql desactivar trigger
SQL
0 vote341 views1 answer
Convert rows to columns in sql server
SQL
-3 votes315 views1 answer
Remove spaces sql 2008
SQL
0 vote287 views1 answer
Finish transaction sql
SQL
0 vote331 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
6 votes333 views1 answer
What is where clause in sql
SQL
0 vote334 views1 answer
Mysql use password error
SQL