SQL Quest › SQL Interview Questions › Querying Basics

Distinct ACRIS Property Types

EasyFreeQuerying Basics

ACRIS property_type codes describe what kind of property a deed/mortgage covers (PS=parking space, CC=condo commercial unit, RE=real property, etc). List distinct property_type values in sales_legals. Order alphabetically.

Solve it in the browser editor →

Runs on SQLite in your browser, graded against the expected result, no signup. A wrong answer gets a diagnosis, not just "incorrect".

Schema

sales_legals

document_idbblproperty_typestreet_numberstreet_nameunit
20260302001740052059330225CR5921PALISADE AVENUENULL
20260311003440133024141401OT280KENT AVENUENRU
20260302004230053043930001AP180WORTMAN AVENUENULL

Expected output: Each ACRIS type once

Hint

SELECT DISTINCT property_type.

Concepts

SELECT DISTINCT ORDER BY

Practise the topic: SQL practice questions

Related questions

Your First QueryEasy · FreePick Your ColumnsEasy · FreeFilter with WHEREEasy · FreeComparison OperatorsEasy · FreeMultiple Conditions (AND / OR)Easy · FreeThe IN OperatorEasy · Free

Where would this cost you points in an interview?

Ten questions, no signup: a Skillmap across nine SQL skills and the one to fix first.

Take the readiness test