> 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/occupations.md).

# Occupations

**Input Format**

The **OCCUPATIONS** table is described as follows:![](https://s3.amazonaws.com/hr-challenge-images/12889/1443816414-2a465532e7-1.png) *Occupation* will only contain one of the following values: **Doctor**, **Professor**, **Singer** or **Actor**.

```sql
CREATE TABLE IF NOT EXISTS occupations (
	name TEXT,
	occupation TEXT);

INSERT INTO occupations VALUES ('Ashley', 'Professor');
INSERT INTO occupations VALUES ('Samantha', 'Actor');
INSERT INTO occupations VALUES ('Julia', 'Doctor');
INSERT INTO occupations VALUES ('Britney', 'Professor');
INSERT INTO occupations VALUES ('Maria', 'Professor');
INSERT INTO occupations VALUES ('Meera', 'Professor');
INSERT INTO occupations VALUES ('Priya', 'Doctor');
INSERT INTO occupations VALUES ('Priyanka', 'Professor');
INSERT INTO occupations VALUES ('Jennifer', 'Actor');
INSERT INTO occupations VALUES ('Ketty', 'Actor');
INSERT INTO occupations VALUES ('Belvet', 'Professor');
INSERT INTO occupations VALUES ('Naomi', 'Professor');
INSERT INTO occupations VALUES ('Jane', 'Singer');
INSERT INTO occupations VALUES ('Jenny', 'Singer');
INSERT INTO occupations VALUES ('Kristeen', 'Singer');
INSERT INTO occupations VALUES ('Christeen', 'Singer');
INSERT INTO occupations VALUES ('Eve', 'Actor');
INSERT INTO occupations VALUES ('Aamina', 'Doctor');	
```