For the attached query, i have written the below code.

WITH BookCounts AS $($

SELECT

COUNT$($b$.$bookid$)$ AS Count,

CONCAT$($a$.$firstname, $\text{'}\text{'},$ a$.$lastname$)$ AS AuthorName,

p$.$publishername AS PublisherName

FROM

Book b

JOIN

Author a ON b$.$author$\_$id $=$ a$.$authorid

JOIN

Publisher p ON b$.$publisherid $=$ p$.$publisherid

GROUP BY

a$.$firstname, a$.$lastname, p$.$publishername

HAVING

COUNT$($b$.$bookid$)>2$

$)$

SELECT $*$ FROM BookCounts

UNION ALL

SELECT $10$ AS Count, 'Thomas Cook' AS AuthorName, 'ABSPublisher' AS PublisherName;

This is my output:

$+-------+---------------+-------------------+$

$|$ COUNT $|$ AUTHORNAME $|$ PUBLISHERNAME $|$

$+-------+---------------+-------------------+$

$|4|$ Harvey Deitel $|$ Prentice Hall $|$

$|3|$ Harvey Deitel $|$ Prentice Hall PTG $|$

$|4|$ Paul Deitel $|$ Prentice Hall $|$

$|3|$ Sean Santry $|$ Prentice Hall $|$

$|5|$ Tem Nieto $|$ Prentice Hall $|$

$|3|$ Tem Nieto $|$ Prentice Hall PTG $|$

$|10|$ Thomas Cook $|$ ABSPublisher $|$

$+-------+---------------+-------------------+$

Still the testcase is failing, Can you please help to fix this,