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 which is the most popular book written in French? 

A select bookname from books where language='French' and popularityrating = (select max(popularityrating) from books where language='French') 
B select bookname from books where language='French' and popularityrating = (select max(popularityrating) from books Having language='French') 
C select bookname,max(popularityrating) from books where language='French' and max(popularityrating) 
D select bookname,max(popularityrating) from books where language='French' having max(popularityrating) 

+ 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