Здравейте,

На тази задача имам нежелан резултат на един от редовете и съм сигурен, че грешката е елементарна, обаче....не я откривам!?!

Ако някой се е преборил и иска да помогне, то моля да посочи как мога да променя входа:)

Ето условието:  Write a query that selects:

• employee_id
• first_name
• project_name

Filter only employees with a project, which has started after 13.08.2002 and it is still ongoing (no end date). Return the first 5 rows sorted by first_name then by project_name both in ascending order.

Example

Ето и кода от мен:

SELECT e.`employee_id`, e.`first_name`, p.`name` AS 'project_name' FROM employees AS e

JOIN employees_projects AS ep ON e.employee_id = ep.employee_id

JOIN projects AS p ON ep.project_id = p.project_id

WHERE DATE(p.start_date) > '2002-08-13' AND DATE( p.end_date) IS NULL

ORDER BY e.first_name ASC , `project_name` ASC LIMIT 5;