Sum and count weird results - Mailing list pgsql-sql

Hi all,
I have these tables

a (
id integer,
email varchar);

b (
seat varchar,
transactionid varchar);

c (
transactionid varchar,
totalprice numeric(8.2));