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 Which is the query to determine the Authors who have written at least 1 book with a popularity rating of less than 5?
A select authorname from authors where authorid in (select authorid from books where popularityrating<5)
B select authorname from authors where authorid in (select authorid from books where popularityrating<=5)
C select authorname from authors where authorid in (select bookid from books where popularityrating<5)
D select authorname from authors where authorid in (select authorid from books where popularityrating in (0,5))
E None
+ AnswerA
+ Report
Total Preview: 2468