kyu7_best_selling_books.sql

-- Best-Selling Books;
--
-- https://www.codewars.com/kata/591127cbe8b9fb05bd00004b
--
-- You work at a book store. It's the end of the month, and
-- you need to find out the 5 bestselling books at your store
-- Use a select statement to list names, authors, and number
-- of copies sold of the 5 books which were sold most
--
-- books table schema
--     name
--     author
--     copies_sold

SELECT name, country FROM travelers WHERE NOT country='Mexico' AND NOT country='USA' AND NOT country='Canada';