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 query will determine how many books have a popularity rating of more than 7 on each subject?

How can a InnoDB database be backed up without locking the tables?

Is it possible to use group by clause to concatenate strings?

How to return a JSON representation of a MySQL query?

Which datatype is used to store binary data in MySQL?

Which statements relating to Alias names is true?

Which is correct in regards to the syntax of the code below? SELECT table1.this, table2.that, table2.somethingelse FROM table1 INNER JOIN table2 ON table1.foreignkey = table2.primarykey WHERE (some other conditions)

Which is not a valid Bit operator?

How can the following error be solved in MySQL? ERROR 1153: Got a packet bigger than 'max_allowed_packet' bytes

Is there any function in MySQL that allows for replace through a regular expression?

Most common use of the mysql EXPLAIN statement?