select LastName, BirthDate,DayName(BirthDate),weekday(BirthDate)  from Employees where weekday(BirthDate) between 0 and 2 and DayOfMonth(BirthDate)>=16;

select LastName, BirthDate from Employees where AddDate('1950-01-01', interval 111 day) <= BirthDate ;

select Week(CurDate()) ;                    

select distinct(MonthName(birthdate)) from Employees order by  length(MonthName(BirthDate)) desc;

ADDDATE( data, INTERVAL liczba jednostka); CURDATE(); DAYOFMONTH();DAYNAME(date); DAYOFWEEK(date); DATEDIFF(data, INTERVAL liczba jednostka); WEEK();