Google Pay Transaction Outcomes

Google

Foundations Track · Easy · 15 min

For January 2024, what are the total counts of successful and failed transactions in each merchant category? This analysis will help the Google Pay security ...

Foundations Track

Easy

15 min

aggregation

filtering

Company labels are directional practice context, not official interview guidance.

Timer 00:00

Back to practice

Objective

Practice aggregation through a Google-tagged business scenario.

Approach

Use this track to lock in clean query structure, basic filtering logic, and confidence with grouped output.

Company context

Company labels are directional practice context, not official interview guidance.

Prereq: query basics

Prereq: filtering

For January 2024, what are the total counts of successful and failed transactions in each merchant category? This analysis will help the Google Pay security team identify potential friction points in payment processing.

fct_transactions

transaction_id INTEGER

merchant_category TEXT

transaction_status TEXT

transaction_date DATE

Editor

SQL workspace

Run queries against the protected question data, then submit once the result shape looks right.

Sign in to run SQL

Create a free account or sign in before running queries against protected question data.