"Projects List" - "Codesignal" #01 - 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/RXErLMFkXFkM4MpYY

Your boss wants to identify the successful projects running in your company, so he asked you to prepare a list of all the currently active projects and their average monthly income.

You have stored the information about these projects in a simple database with a single Projects table that has five columns:

internal_id: the company's internal identifier for the project;
project_name: the official name of the project;
team_size: the number of employees working on the project;
team_lead: the name of the project manager;
income: the average monthly income of the project.
Your boss says that internal project ids are irrelevant to him and that he isn't interested in how big the teams are. Since that's the case, he wants you to create another table by removing the internal_id and team_size columns from the existing Projects table. Return it sorted by internal_id 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