/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 vote129 views1 answer
Find duplicate users by email address in mysql
SQL
1 vote146 views2 answers
Laravel jwt generate token
SQL
4 votes126 views4 answers
Check constraint in ms sql
SQL
10 votes128 views1 answer
How to import database in mysql by cmd
SQL
9 votes166 views3 answers
Pyodbc connect to sql server
SQL
0 vote118 views1 answer
Not equal to blank in mysql
SQL
1 vote101 views1 answer
Real world example of nosql
SQL
0 vote128 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote130 views3 answers
Mysql keyword search
SQL
-1 vote120 views2 answers
Postgresql get last 10 records
SQL