Single-Line SQL: Retrieve User Names | Dataford Interview Questions

Phenom needs a simple administrative query for retrieving the names of users registered on its platform. Write a single-line PostgreSQL query that returns the name for every row in the users table.

Requirements

Select only the name column.
Return every user, including users who share the same name.
Do not add filters, joins, aggregations, or subqueries.

Schema

users

Column	Type	Description
user_idPK	INTEGER	Unique identifier for the user
name	VARCHAR(150)	User's display name
email	VARCHAR(255)	User's email address
account_status	VARCHAR(20)	Current account status

Your question is Single-Line SQL: Retrieve User Names. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Phenom needs a simple administrative query for retrieving the names of users registered on its platform. Write a single-line PostgreSQL query that returns the name for every row in the users table.

Requirements

Select only the name column.
Return every user, including users who share the same name.
Do not add filters, joins, aggregations, or subqueries.

Schema

users

Column	Type	Description
user_idPK	INTEGER	Unique identifier for the user
name	VARCHAR(150)	User's display name
email	VARCHAR(255)	User's email address
account_status	VARCHAR(20)	Current account status

Your question is Single-Line SQL: Retrieve User Names. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.