# QUACKSTARTER

WEEKLY QUACK CHALLENGE! · challenge 2 · medium · 5 guesses

> Venture Scout Widgeon scrolls through the Quackstarter dashboard, feathers ruffled. "Everyone's 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 I'll have to take your bread crumbs away!"

## 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 |

## Data

The tables live in a DuckDB database: https://dbquacks.com/data/databases/weekly_202628_02_quackstarter.duckdb

To query it outside the browser, attach it read-only:

```sql
ATTACH 'https://dbquacks.com/data/databases/weekly_202628_02_quackstarter.duckdb' AS db (READ_ONLY);
USE db;
```

Play it in the browser: https://dbquacks.com/challenges/weekly/2

## Answer

The expected answer is not published. Submit on the page to have it checked.