> For the complete documentation index, see [llms.txt](https://dshub.gitbook.io/ds-hub/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dshub.gitbook.io/ds-hub/sql/sql-practice/popular-websites-for-sql-practice/hackerrank/tables/students.md).

# Students

The **STUDENTS** table is described as follows: ![](https://s3.amazonaws.com/hr-challenge-images/12896/1443815243-94b941f556-1.png) 

The *Name* column only contains uppercase (`A`-`Z`) and lowercase (`a`-`z`) letters.

**Sample Input**

![](https://s3.amazonaws.com/hr-challenge-images/12896/1443815209-cf4b260993-2.png)

```sql
CREATE TABLE IF NOT EXISTS students_hackerrank(
	id INT,
	name TEXT,
	marks INT);
	
INSERT INTO students VALUES (19, 'Samantha', 87);
INSERT INTO students VALUES (21, 'Julia', 96);
INSERT INTO students VALUES (11, 'Britney', 95);
INSERT INTO students VALUES (32, 'Kristeen', 100);
INSERT INTO students VALUES (12, 'Dyana', 55);
INSERT INTO students VALUES (13, 'Jenny', 66);
INSERT INTO students VALUES (14, 'Christene', 88);
INSERT INTO students VALUES (15, 'Meera', 24);
INSERT INTO students VALUES (16, 'Priya', 76);
INSERT INTO students VALUES (17, 'Priyanka', 77);
INSERT INTO students VALUES (18, 'Paige', 74);
INSERT INTO students VALUES (19, 'Jane', 64);
INSERT INTO students VALUES (21, 'Belvet', 78);
INSERT INTO students VALUES (31, 'Scarlet', 80);
INSERT INTO students VALUES (41, 'Salma', 81);
INSERT INTO students VALUES (51, 'Amanda', 34);
INSERT INTO students VALUES (61, 'Heraldo', 94);
INSERT INTO students VALUES (71, 'Stuart', 99);
INSERT INTO students VALUES (81, 'Aamina', 77);
INSERT INTO students VALUES (76, 'Amina', 89);
INSERT INTO students VALUES (91, 'Vivek', 84);
INSERT INTO students VALUES (17, 'Evil', 79);
INSERT INTO students VALUES (16, 'Devil', 76);
INSERT INTO students VALUES (34, 'Fanny', 75);
INSERT INTO students VALUES (38, 'Danny', 75);
```