Question:Consider the following tables:
Books
------
BookId
BookName
AuthorId
SubjectId
PopularityRating       (the popularity of the book on a scale of 1 to 10)
Language               (such as French, English, German etc)

Subjects
---------
SubjectId
Subject    (such as History, Geography, Mathematics etc)

Authors
--------
AuthorId
AuthorName
Country

What is the query to determine the names of the Authors who have written more than 1 book? 

A select AuthorName from Authors where AuthorId in (select AuthorId from Books group by AuthorId having count(*)>1) 
B select AuthorName from Authors, Books where Authors.AuthorId=Books.AuthorId and count(BookId)>1 
C select AuthorName from Authors, Books where Authors.AuthorId=Books.AuthorId group by AuthorName having count(*)>1 
D select AuthorName from Authors where AuthorId in (select AuthorId from Books having count(BookId)>1) 

+ Answer
A 

+ Report

Md. Habib Ullah

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description