update public.consultant set avg_score = 1 where agent_no = 'A183619275';
|
update public.consultant set avg_score = 2 where agent_no = 'AGAM11249699';
|
update public.consultant set avg_score = 3 where agent_no = 'Z152717443';
|
update public.consultant set avg_score = 4 where agent_no = 'D265260662';
|
update public.consultant set avg_score = 5 where agent_no = 'AG0109051204';
|
update public.consultant set avg_score = 1 where agent_no = 'B282677963';
|
update public.consultant set avg_score = 2 where agent_no = 'AG0101234567';
|
update public.consultant set avg_score = 3 where agent_no = 'X147309614';
|
update public.consultant set avg_score = 4 where agent_no = 'J149388015';
|
update public.consultant set avg_score = 5 where agent_no = 'R221444250';
|
|
do
|
$$
|
declare
|
avg_row record;
|
begin
|
for avg_row in select round(cast(avg(score) as numeric), 1) as avg_score, agent_no from public.satisfaction where "type" = 'APPOINTMENT' and score is not null group by agent_no
|
loop
|
update public.consultant set avg_score = avg_row.avg_score where agent_no = avg_row.agent_no;
|
end loop;
|
end
|
$$
|
