-- Проверяем ДЗ №1 select batch.id, batch.start_period, concat(rnk.name, ' ', usr.name) as user, batch.pos_x, batch.pos_y from measurement_batch batch join users usr on batch.user_id = usr.id join ranks rnk on usr.rank_id = rnk.id;