computational question - Mailing list pgsql-general

From tlharvey@alumni.princeton.edu (Tyrone)
Subject computational question
Date
Msg-id 469afb39.0211010942.4ca56cfd@posting.google.com
Whole thread Raw
List pgsql-general
Novice user needs to calculate students' total points based on three
highest quiz scores.

Rows are students; columns represent quiz (and other) scores.  I want
to know how to write a program that takes the three highest quiz
scores from [Q1], [Q2], [Q3], and [Q4].  I then simply need to average
those scores for each student.

Thanks.

pgsql-general by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: [SQL] Copying a rowtype variable.
Next
From: dodo@interlinx.it (Doriano Azzena)
Date:
Subject: Re: PGDATESTYLE + SuSe 8.0