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 how many books have been written on each subject. Displaying Name of Subject and count of the Books?

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?

Which one is not a SQL operator?

Which ones are aggregate functions in SQL?

Which is not (a) valid binary datatype in SQL Server?

What is the correct SQL syntax for selecting all the columns where the 'LastName' is alphabetically between (and including) 'Hansen' and 'Pettersen'?

Which one must be specified in every DELETE statement?

___________ is the highest level of a transaction isolation implemented by SQL Server.

A table has following values for its department field: marketing, production, production, sales, NULL, NULL, Marketing, Null What will the following query return: Select distinct(department) from employees

Which one is an invalid statement for manipulation of binary data?

Which of the following is not a control statement?