SQL Challenges · WEEKLY QUACK CHALLENGE!
QUACKSTARTER
Difficulty: medium
Venture Scout Widgeon scrolls through the Quackstarter dashboard, feathers ruffled. Everyones honking about comics — they raised the most coin! And music has five whole projects! But quack quack, Duckbert — raw money and sheer volume are rookie traps! The real winner is the category where projects actually cross their finish line. Backers trust those creators! Find the category with the highest share of funded projects, or Ill have to take your bread crumbs away!
Your task
A project is funded when its total pledged amount is at least its goal. A category’s success rate is the fraction of its projects that are funded. Return the name of the category with the highest success rate; on a tie, the alphabetically first. You will be working with the `projects` and `pledges` tables.
Tables
projects (15 rows)
| column | type |
|---|---|
project_id | INTEGER |
name | VARCHAR |
goal | INTEGER |
category | VARCHAR |
pledges (33 rows)
| column | type |
|---|---|
pledge_id | INTEGER |
project_id | INTEGER |
backer_id | INTEGER |
ts | TIMESTAMP |
amount | INTEGER |
Database: https://dbquacks.com/data/databases/weekly_202628_02_quackstarter.duckdb
This page as markdown: https://dbquacks.com/challenges/weekly/2.md