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 number of Authors who have written books on more than 2 subjects?

Which operator will be evaluated first in the following statement: select (age + 3 * 4 / 2 - 8) from emp

What does DETERMINISTIC mean in the creation of a function?

What is wrong with the following statement? create table foo (id int auto_increment, name int);

Maximum size of a row in a MyISAM table?

What is the correct order of clauses in the select statement? 1 select 2 order by 3 where 4 having 5 group by

Which optimization tips holds true?

Which forms of the SELECT statement writes a single row to a f‌ile without any formatting?

Which is INCORRECT regarding the DECIMAL data type?

Which data type has been deprecated in MySQL 5.6?

What will be the result? SELECT CONCAT('MY', 'S', 'QL')