By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table books(
author_fname varchar(25),
author_lname varchar(25),
pages int,
released_year int);
select
concat(
author_fname,
' ',
author_lname,
' have released his firest book at ',
min(released_year),
' and it''s ',
pages,
' were released_year ',
min(released_year),
' pages') as 'info'
from books
group by
author_lname,
author_fname,
pages;