Average

[Guest_imported]

Let's say I have a table set up like this

Number 1 Number 2
1 7
15 29
6 4

Is there a simple way to average together Number 1 and Number 2 from the same row? Like the first row would be 4.

 

[piti]

what about this:
select ((Number1 + Number2)/2) as average from table