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.

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 de

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site