kur2

use plant_service;
select concat(u.first_name," ",u.last_name) as first_name,u.username,c.name as city,year(u.register_date) as register_year from users as u
join cities as c on u.city_id=c.id
where((first_name is not null) and u.id not in (select orders.user_id from orders))
order by register_year asc,first_name asc