Practice SQL Question | Real Coding Interviews | Hack2hire

NewML System Design & SQL tracks just landedSee what's new

Question Bank Pricing Blog Forum

Quick Summary

Count filings matching two distinct product name prefixes.
Return results as a single row with dedicated columns for each product.
Gracefully handle scenarios where matching records are absent or the table is empty.

What This Tests

Conditional aggregation for simultaneous metric calculation.
Pattern matching on string attributes.
Handling zero-count edge cases in summary queries.
Designing flat summary outputs without explicit grouping.

Common Patterns

Aggregation

String Manipulation

Test Cases

Input

-

Output

-

Expected

-