How to fix syntax error?

Question

MySQL

The whole task sounds like this:
It is necessary to draw up a "Payroll" (salary-13%). If there are minor children, one minimum wage is not taxed.
Employees

Children

Positions: The

catch is that it is not possible to check the age of majority of the eldest child.

case when ( year(now()) - year(select Дети.birth from Дети,Сотрудники where Сотрудники.pers_number = Дети.pers_number_parr order by Дети.birth limit 1)<=18) then

Here is the program code in its entirety:

select pers_number,fio,
case when ( year(now()) - year(select Дети.birth from Дети,Сотрудники where Сотрудники.pers_number = Дети.pers_number_parr order by Дети.birth limit 1)<=18) then 
0.87*(select salary from Должности where Должности.name_pos=Сотрудники.position)-0.13*5965 else 
(
    (select salary from Должности where Должности.name_pos=Сотрудники.position)*0.87
)
end as salary
from Сотрудники;

MySql swears at the syntax:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where year(now()) - year(select Дети.birth from Дети,Сотрудник' at line 2

Please help me find the cause of the error.

Answer 1

well, firstly, in the second query, select pers_number, fio, the comma is superfluous

Answer 2

Well, he swears correctly, read the case documentation . You need an if, on the same page.