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". Free accounts get 10 free challenge solves, and this can be one of them.

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

Read the concept: Learn SQL for beginners

Related questions

National Association BanksEasy · FreeTop 10 Manhattan Properties by Assessed ValueEasy · FreePre-1920 NYC BuildingsEasy · FreeLLC and Realty OwnersEasy · FreeTop 10 by Tool WearEasy · FreeHigh-Quality Products OnlyEasy · 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