"Automatic Notifications" - Codesignal #05 - MySQL Solution

Try these popular MySQL tutorial books this year:
1. SQL Cookbook - O'Reilly
https://amzn.to/31mTIRz
2. SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a "learn-by-doing" approach
https://amzn.to/37lcL2G
3. SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
https://amzn.to/3o2v02H
*As an Amazon Associate I earn from qualifying purchases.
*******************************************************************************************
Like and Subscribe if you enjoy my content!
Or give advice or alternative solutions in the comments below!
Problem: https://app.codesignal.com/arcade/db/welcome-to-the-table/kaxWej78qgdGHy8mr

The application you've been working on for the past year is a huge success! It already has a large and active user community. You know the ID number, username, and email of each user. Each user also has a specific role that shows their position in the community. Information about the users is stored in the database as a table users, which has the following structure:

id: the unique user ID;
username: the username of the user;
role the user's role;
email: the user's email.
You want to send users automatic notifications to let them know about the most recent updates. However, not all users should get these notifications: Administrators don't need notifications since they know about the updates already, and premium users don't need them since they get personalized weekly updates.

Given the users table, your task is to return the emails of all the users who should get notifications, i.e. those whose role is not equal to "admin" or "premium". Note that roles are case insensitive, so users with roles of "Admin", "pReMiUm", etc. should also be excluded.

The resulting table should contain a single email column and be sorted by emails in ascending order.

More CodeSignal: https://www.youtube.com/playlist?list=PL_-8xV0NOEOLomcDPrnylyMWnoTWYjB6u

More LeetCode: https://www.youtube.com/playlist?list=PL_-8xV0NOEOL4iZ2aJkqHR9nJrxgNJonr

More HackerRank: https://www.youtube.com/playlist?list=PL_-8xV0NOEOKC3tyHATcBvJiXCV0UR32I

*******************************************************************************************

Follow me on:
Twitter - https://twitter.com/JoshuaCadavez
LinkedIn - https://www.linkedin.com/in/joshuacadavez
GitHub - https://github.com/JoshuaTheEngineer