code signal solution for https://app.codesignal.com/challenge/GdySWgE8BNrxdHiGZ

mischievousNephews.mysql

CREATE PROCEDURE mischievousNephews()
BEGIN
    SELECT 
        WEEKDAY(mischief_date) AS weekday,
        mischief_date,
        author,
        title 
    FROM 
        mischief 
    ORDER BY 
        weekday,
        FIELD(author, 'Huey', 'Dewey' ,'Louie'), 
        mischief_date,
        title;
END