[HackerRank](E) Employee Names

https://www.hackerrank.com/challenges/name-of-employees/problem?isFullScreen=true 

Employee Names | HackerRank

 

[문제]

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.

 

[답]

-mysql

select name from employee
order by name;

단순히 이름으로 오름차순 정렬만 해주면 되는 쿼리이다.