Sort Student Names

Home Problems Compete Ranks Pricing

Sign up Log in

Sort Student Names

Time Limit for Unknown

1 seconds

Memory Limit for Unknown

32 MB

Easy

You are given the student record of a school containing the student id, name and the age. Your task is to report the id, name and the age in alphabetical order based on the student name.

Input

You will be given a table Students with 3 columns: id, name and age. id is the primary key of the table. Names will always start with an upppercase letter and there are no two students with the same name.

Output

Write a query to show all the students but the names should be in alphabetical order.

Sample

input

Students

id (BIGINT)	name (TEXT)	age (BIGINT)
1	Alice	12
2	Dan	15
3	Bob	11
4	Mike	17
5	John	10

Click to copy

{ "headers": { "Students": ["id", "name", "age"] }, "rows": { "Students": [ [1, "Alice", 12], [2, "Dan", 15], [3, "Bob", 11], [4, "Mike", 17], [5, "John", 10] ] } }

Click to copy

DROP TABLE IF EXISTS Students; CREATE TABLE Students ( id BIGINT, name TEXT, age BIGINT ); INSERT INTO Students VALUES (1, "Alice", 12), (2, "Dan", 15), (3, "Bob", 11), (4, "Mike", 17), (5, "John", 10);

output

Students

id (BIGINT)	name (TEXT)	age (BIGINT)
1	Alice	12
3	Bob	11
2	Dan	15
5	John	10
4	Mike	17

Click to copy

{ "headers": { "Students": ["id", "name", "age"] }, "rows": { "Students": [ [1, "Alice", 12], [3, "Bob", 11], [2, "Dan", 15], [5, "John", 10], [4, "Mike", 17] ] } }

Click to copy

DROP TABLE IF EXISTS Students; CREATE TABLE Students ( id BIGINT, name TEXT, age BIGINT ); INSERT INTO Students VALUES (1, "Alice", 12), (3, "Bob", 11), (2, "Dan", 15), (5, "John", 10), (4, "Mike", 17);

Total Submissions

Users Tried

Users Solved

No tutorial available for this problem. But if you know how to solve this problem, then please contribute to our tutorials repository.