MCQs>IT & Programming>Hadoop>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 the names of the Authors who have written more than 1 book?
Hadoop 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
What is the query to determine the names of the Authors who have written more than 1 book?
Answer
Correct Answer:
Explanation:
Note: This Question is unanswered, help us to find answer for this one