Volunteer Appreciation Reward

Problem

Table: `Volunteers`

```text
+--------------+---------+
| Column Name | Type |
+--------------+---------+
| volunteer_id | int |
| full_name | varchar |
| base_hours | int |
+--------------+---------+
volunteer_id is the primary key for this table.
Each row holds a volunteer's ID, name, and the hours they logged this term.
```

A charity runs a quirky appreciation lottery. A volunteer earns a reward equal to `100%` of their base_hours **only if** their volunteer_id is **an odd number** **and** their full_name does **not** start with the letter `'T'`. Otherwise their reward is `0`.

Write a solution to compute each volunteer's `reward`.

Return the result table ordered by `volunteer_id` ascending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 5 rows with the columns volunteer_id, reward.

Starter code (SQL)

SELECT *
FROM Volunteers;

Related SQL questions

• Above-Average CampusesEasy
• Adjacent Open Parking SpotsEasy
• App Ad Click-Through RateEasy
• Asset Labels With a Three-Digit CodeEasy
• Average Listening Sessions per ListenerEasy
• Average Nightly Rate Earned per RoomEasy