> > >

MySQL MCQs

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
Which is the query to determine the Authors who have written at least 1 book with a popularity rating of less than 5?

select authorname from authors where authorid in (select authorid from books where popularityrating<5)

select authorname from authors where authorid in (select authorid from books where popularityrating<=5)

select authorname from authors where authorid in (select BookId from books where popularityrating<5)

select authorname from authors where authorid in (select authorid from books where popularityrating in (0,5))

Answer

Correct Answer: select authorname from authors where authorid in (select authorid from books where popularityrating<5)

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it