user
Construct a query for retrieving the top 10 books in the “Mystery” genre from an online bookstore database.

assistant
SELECT title, author, rating 
FROM books 
WHERE genre = 'Mystery' 
ORDER BY rating DESC 
LIMIT 10