Hello Friends in this article i am gone to share Hacker Rank SQL Solutions with you | Employee Names Solution

Also Visit:  Higher Than 75 Marks SQL Solution

Problem

Write a query that prints a list of employee names (i.e.: the name attribute) from the Employee table in alphabetical order.

Input Format

The Employee table containing employee data for a company is described as follows:

where employee_id is an employee’s ID number, name is their name, months is the total number of months they’ve been working for the company, and salary is their monthly salary.

Sample Input

Sample Output

Angela 
Bonnie 
Frank 
Joe 
Kimberly 
Lisa 
Michael 
Patrick 
Rose 
Todd

Solution – Employee Names Solution

MySQL Code

SELECT name FROM employee ORDER BY name;

Disclaimer: The above Problems are generated by Hacker Rank but the Solutions are Provided by NYANDER.COM. All Hacker Rank SQL Solutions Shared only for Educational and Learning Purpose.