1,105,585 Community Members

SQL Database language

Member Avatar
ANSAYLOR
Newbie Poster
1 post since Mar 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hello!
I am working on an SQL Database project and I am supposed to find the names of authors who have written 3 or more books. My code is below. The operator ">" is not valid and I have tried different variations of COUNT.

SELECT afirstname, alastname, btitle, COUNT(*) FROM Author, Book WHERE btitle > 2 GROUP BY alastname;

Author contains the names and Book contains the titles, pages, etc. There is also Author_Book containing aid and bid. Do I need to use a join? I still don't understand how I can specify 3+ books without using an operator. I am not asking for an answer, just some pointers if possible :).

Thank you!

Member Avatar
pritaeas
mod_pritaeas
11,309 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,835 [?]
Skill Endorsements: 155 [?]
Moderator
Featured
Sponsor
 
0
 

Have a look at using COUNT in HAVING.

Since btitle is a varchar column, you cannot compare it to an integer (it does not know you want to count).

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article