Bookends of the Week

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

Domain

SQL

Difficulty

hard

Seniority

L4

Problem

A payments team is profiling how each week's spending clusters around its two edges, Monday and Sunday. For every week, give the percentage of that week's transaction volume that fell on Monday and the percentage that fell on Sunday, each rounded to the nearest whole number, earliest week first.

Summary

Every week has two edges. Weigh what lands on each.

Practice This Problem

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