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

L3

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.

Summary

Long queries with 'er'. A pattern?

Practice This Problem

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