sql - HAVING more than 2 books -

I have to print only those publishers who publish more than 2 books, but for my results, I always

  PUB_NAME | Total -------------------------------- Abatis Publisher | Book 4 core dump. 1 & amp; Lt; ------ Do not want to print. Press 3 | Tenterhooks Press | 5  

Error 42X01: syntax error: attributed "HAVING"

This is my code so far.

  SELECT pub_name, get titles from COUNT (title_name) publishers with the total INNER title. Pub_id = publishers.pub_id GROUP by pub_name; Overall & gt; 2;  

TOTAL is not identified in HAVING HAVING COUNT (title_name)> 2;

Also try ';' Pub_name in group;