Hacker Rank SQL

Employee Names Solution

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:

Column Type
employee_id Integer
name String
months Integer
salary Integer

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

employee_id name months salary
12228 Rose 15 1968
33645 Angela 1 3443
45692 Frank 17 1608
56118 Patrick 7 1345
59725 Lisa 11 2330
74197 Kimberly 16 4372
78454 Bonnie 8 1771
83565 Michael 6 2017
98607 Todd 5 3396
99989 Joe 9 3573

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.