Debugging errors

Debugging is an essential skill for all coders, and it comes from making many mistakes and learning from them.

In this exercise, you'll be given some buggy code that you'll need to fix.

Instructions $1/3$

$35$ XP

$1$

Debug and fix the SQL query provided.

Take Hint $(-10$ XP$)$

$2$

Find the two errors in this code; the same error has been repeated twice.

$3$

Find the two bugs in this final query.