Just wondering how write the sql script for the following question: For each event, list the prize money available for first, second and third prize...

Just wondering how write the sql script for the following question:

For each event, list the prize money available for first, second and third prize on

one line. Group by event_id.

For example, one row of the results would appear as:

Event_id First Second Third

101 120 60 30