In sql I am trying to find the average of how many contribut
In sql I am trying to find the average of how many contributions did each contributor make?
 -- Give a single number, rounded to one digit to the right of the decimal point.
the table looks like
CREATE TABLE contribution
 (
 contb_id   integer primary key,
 cand_id   varchar(12),
 contbr_id   varchar(12),
 amount   numeric(6,2),
 date       varchar(20),
 election_type varchar(20),
 tran_id   varchar(20)
 );
Solution
SELECT AVG(amount) from contribution;
The above sql query gives the average contribution made by the contributors.

