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 how many books have been written on each subject. Displaying Name of Subject and count of the Books? 

A select subject,count(*) from books,subjects where books.subjectid=subjects.subjectid group by books.subjectid 
B select count(*),subject from books,subjects where books.subject.id=subjects.subject.id group by subjects.subject 
C select subject,count(*) from books,subjects where books.Authorid=subjects.Authorid group by books.subjectid,subjects.subject 
D select subject,count(*) from books,subjects where books.BookId=subjects.BookId group by books.subjectid,subjects.subject 

+ 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