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 German books(if any) are more popular than all the French? 

A select bookname from books where language='German' and popularityrating = (select popularityrating from books where language='French') 
B select bookname from books where language='German' and popularityrating > (select popularityrating from books where language='French') 
C select bookname from books where language='French' and popularityrating > (select max(popularityrating) from books where language='German') 
D select bookname from books where language='German' and popularityrating > (select max(popularityrating) from books where language='French') 

+ Answer
D 

+ 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