SQL Query to Find Objects

EasySQL · PostgreSQL

Problem

Write an SQL query for objects. Assume a table named objects stores one record per object. Return every object record with its identifying and classification details, including rows with missing optional values.

Output

One row per object
Columns: object_id, object_name, object_type, and status
Sort results by object_id in ascending order

Schema

objects

Column	Type	Description
object_idPK	INT	Unique identifier for the object
object_name	VARCHAR(100)	Name assigned to the object
object_type	VARCHAR(50)	Classification of the object
status	VARCHAR(20)	Current status of the object

Tablesobjects

CodePostgreSQL

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

Run your query to see results here.