create table book
(
book_id integer primary key,
name varchar(128) not null,
release_date date not null
);

create table orders
(
order_id integer primary key,
book_id integer not null,
quantity integer not null,
dispatch_date date not null,
foreign key (book_id) references book(book_id)
);

select b.book_id
from book b
where release_date < date_sub(curdate(), interval 1 month)
inner join (select book_id from orders
where dispatch_date > date_sub(curdate(), interval 1 YEAR) having sum(quantity) < 10 group by book_id; 
) o
on b.id == o.book_id