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)
What is the query to determine which German books (if any) are more popular than all the French books?
Correct Answer:
Select bookname from books where language='German' and popularityrating > (Select max(popularityrating) from books where language='French')
Explanation:
Note: This Question is unanswered, help us to find answer for this one
More Access MCQ Questions