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 :).
2 Months Ago
Related Article:sample asp.net with c# sql database connection
is a MS SQL discussion thread by sudarsanan2k9 that has 1 reply, was last updated 7 months ago and has been tagged with the keywords: sample, asp.net, with, c#, sql, database, connection.