Lesson 23 - Broken grader and Lesson 25 – incorrect expected results

[VennelaO-O]

Lessons affected:

• Lesson 23: https://www.sql-easy.com/lessons/23-joins-with-where/
• Lesson 25: https://www.sql-easy.com/lessons/25-table-alias/

Lesson 23 Problem:

• The code does not run at all.
• In sqlteaching.js, the required values include "Willow Rosenberg" and "How I Met Your Mother", even though the exercise says to exclude them.
• The answer only lists "Doogie Howser", which is incomplete.
• Result: No SQL query can pass.

Lesson 25 Problem:

• The exercise runs, but the expected result is inconsistent.
• The prompt asks for LEFT JOIN with aliases between character, character_actor, and actor.
• A correct LEFT JOIN query returns multiple rows (Neil Patrick Harris + Alyson Hannigan + nulls).
• The grader only accepts Neil Patrick Harris rows.
• Result: Correct queries are marked incorrect.

Suggested Fix:

• Update Lesson 23’s validator: remove "Willow Rosenberg" and "How I Met Your Mother" from required; update answer.values to include all valid rows.
• Update Lesson 25’s expected results so they match the true SQL LEFT JOIN output with aliases.