DB Exercises
0
← Exercises/
Fundamentals•9 of 12
PrevNext
FundamentalsBeginnerPRO

Product Catalog Wildcard Pattern Search

Scenario

The merchandising team is running a summer electronics promo. They need to locate all audio accessories whose product title contains the keyword 'Wireless' or 'Bluetooth' and whose retail price is under $100.

Task
Query the `products` table to find items where: - `category` equals `'Audio'` - `product_title` contains either `'Wireless'` or `'Bluetooth'` (using the SQL `LIKE` operator) - `retail_price` is strictly less than **100.00** Return: 1. `sku` 2. `product_title` 3. `retail_price` 4. `in_stock` Order the result by `retail_price` ascending, breaking ties by `sku` ascending.
Expected Output Format

Budget wireless and Bluetooth audio products sorted by price ascending.

Input Tables & Sample Data0 tables
Loading database schema...
Need a hint?
query.sql|Local Sandbox
Loading SQL editor...
Click "Run" or press ⌘ + Enter to execute your query

About the “Product Catalog Wildcard Pattern Search” SQL Problem

Business Scenario

The merchandising team is running a summer electronics promo. They need to locate all audio accessories whose product title contains the keyword 'Wireless' or 'Bluetooth' and whose retail price is under $100.

Expected Output & Criteria

Budget wireless and Bluetooth audio products sorted by price ascending.

Database Table Schema (PostgreSQL DDL)

PostgreSQL 16 WASM

This challenge executes directly against the following relational schema in your browser:

CREATE TABLE products (
        sku VARCHAR(20) PRIMARY KEY,
        product_title VARCHAR(150) NOT NULL,
        category VARCHAR(50) NOT NULL,
        retail_price NUMERIC(10, 2) NOT NULL,
        in_stock INT NOT NULL
      );

Target SQL Clauses & Operators

WHERELIKEORDER BY

Want more Fundamentals practice?

Explore the full syllabus of 12 exercises, syntax guides, and interview pitfalls.

View Fundamentals Track→