opg10.sql.txt sid | sname -----+--------- 22 | Dustin 64 | Horatio (2 rows) opg11.sql.txt avg ------ 25.5 (1 row) opg12.sql.txt sname | age -------+------ Bob | 65.3 (1 row) opg13.sql.txt antall -------- 9 (1 row) opg14.sql.txt sname | sid --------+----- Dustin | 22 Lubber | 31 Bob | 95 (3 rows) opg15.sql.txt rating | sid | sname | age --------+-----+---------+------ 1 | 29 | Brutus | 33 3 | 85 | Art | 25.5 7 | 22 | Dustin | 45 8 | 32 | Andy | 25.5 9 | 64 | Horatio | 35 9 | 74 | Horatio | 35 10 | 71 | Zorba | 16 (7 rows) opg16.sql.txt rating | sid | sname | age --------+-----+---------+------ 3 | 85 | Art | 25.5 8 | 32 | Andy | 25.5 9 | 64 | Horatio | 35 9 | 74 | Horatio | 35 10 | 58 | Rusty | 35 (5 rows) opg17.sql.txt rating | avg --------+------------------ 10 | 25.5 9 | 35 8 | 40.5 3 | 45.4000015258789 (4 rows) opg1.sql.txt sname --------- Dustin Lubber Horatio (3 rows) opg2.sql.txt sname --------- Dustin Lubber Horatio (3 rows) opg3.sql.txt color ------- green red (2 rows) opg4.sql.txt sname --------- Horatio Lubber Dustin (3 rows) opg5.sql.txt sid | sname -----+--------- 22 | Dustin 31 | Lubber 64 | Horatio 74 | Horatio (4 rows) opg6.sql.txt sid ----- 22 31 (2 rows) opg7.sql.txt sname --------- Horatio Lubber Dustin (3 rows) opg8.sql.txt sid ----- 74 (1 row) opg9.sql.txt sid ----- 22 (1 row)