Long Searches Containing 'er'

A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

easy

Seniority

junior

Problem

The search analytics team is investigating long-tail query patterns. Pull all search queries where the term is longer than 12 characters and ends with the letter 'r' (case-insensitive). Return all fields, ordered by query ID.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.