Составить запрос для MySQL

SELECT a.*, b.*, count(b.auth_id) as b_count FROM authors a LEFT JOIN books b on (b.author_id = a.id) GROUP BY b.auth_id having b_count > 3;

select

t1.id_autor,

t1.autor,

count(*) as count

form autors t1

inner join knigi t2 on t2.id_autor = t1.id_autor

group by t1.id_autor, t1.autor

having count > 3