Single-Line SQL: Retrieve User Names

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Single-Line SQL: Retrieve User Names. Start with the requirements and the one table on the right.

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

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

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

Your solutionPostgreSQL

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

Run a query to see results