Single-Line SQL: Retrieve User Names

EasySQL · PostgreSQL

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

Tablesusers

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.