1.
sid	sname	rating	age
31	Lubber	8	55.5
32	Andy	8	25.5
58	Rusty	10	35.0
71	Zorba	10	16.0
74	Horatio	9	35.0

2.
sname	bid	day
Dustin	101	2010-10-01
Dustin	102	2010-10-02
Dustin	103	2010-10-03
Dustin	104	2010-10-04
Lubber	102	2010-10-05
Lubber	103	2010-10-06
Lubber	103	2010-11-03
Lubber	104	2010-10-07
Lubber	104	2010-11-04
Horatio	101	2010-10-08
Horatio	101	2010-11-01
Horatio	102	2010-10-09
Horatio	102	2010-11-02
Horatio	103	2010-10-10
[14]

3.
sname	age
Dustin	45.0
Brutus	33.0
Lubber	55.5
Andy	25.5
Rusty	35.0
Horatio	35.0
Zorba	16.0
Horatio	35.0
Art	25.5
Bob	63.5
[10]

4.
sname	age
Dustin	45.0
Brutus	33.0
Lubber	55.5
Rusty	35.0
Horatio	35.0
Horatio	35.0
Bob	63.5
[7]

5.
bname
Interlake

6.
sid
22
31
64

7.
sname
Bob

8.	36.9
9.	25.5
10.	Horatio(2)

11.a
bid	COUNT(sid)
101	3
102	4
103	4
104	3

11.b
bid	bname	COUNT(R.sid)
101	Interlake	3
102	Interlake	4
103	Clipper	4
104	Marine	3

12.
bid	bname	COUNT(distinct R.sid)
101	Interlake	2
102	Interlake	3
103	Clipper	3
104	Marine	2

13.
bid	bname	COUNT(distinct R.sid)
101	Interlake	1

14.
sid	sname
22	Dustin
31	Lubber
74	Horatio

15.
sid	sname
29	Brutus
32	Andy
58	Rusty
64	Horatio
71	Zorba
85	Art
95	Bob

16.
sid	sname
22	Dustin
31	Lubber
64	Horatio

17.
red
green

18.
sid	sname
22	Dustin
31	Lubber
64	Horatio
74	Horatio

19.
sid	sname
22	Dustin
31	Lubber
64	Horatio
74	Horatio

20.
sid	sname
22	Dustin
31	Lubber

21.
sid	sname
29	Brutus
32	Andy
58	Rusty
74	Horatio
85	Art
95	Bob

22.
sid	sname
22	Dustin
31	Lubber
64	Horatio

23.	74

24.
sid	sname
74	Horatio

Q20.	58,71,22,31

25
sid	sname
29	Brutus
32	Andy
58	Rusty
71	Zorba
74	Horatio
85	Art
95	Bob

26a
sid	sname	rating
31	Lubber	8
32	Andy	8
58	Rusty	10
71	Zorba	10
74	Horatio	9

26b
sid	sname	rating
58	Rusty	10
71	Zorba	10

27
sid	sname	rating
58	Rusty	10
71	Zorba	10

28
sid	sname	age
95	Bob	63.5

29.	10
30.	9
31.	101

32.
sid	sname	age
22	Dustin	45.0
31	Lubber	55.5
95	Bob	63.5

33.
rating	MIN(S.age)
1	33.0
3	25.5
7	35.0
8	25.5
9	35.0
10	16.0

34.
rating	MIN(S.age)
3	25.5
7	35.0
8	25.5

35.
bid	COUNT(*)
102	4
104	3

36a
rating	AVG(S.age)
3	44.5
7	40.0
8	40.5
10	25.5

36b
rating	MAX(S.age)
3	63.5
7	45.0
8	55.5
10	35.0

37.
bid	sid	cnt
101	64	2
102	64	2
103	31	2
104	31	2

38
bid	cnt
102	4
103	4

39.
bid	bname	cnt
101	Interlake	3
102	Interlake	4
103	Clipper	4
104	Marine	3
109	HKSAR

40.
sid	sname
29	Brutus
32	Andy
58	Rusty
71	Zorba
74	Horatio
85	Art
95	Bob
[7]

41
sid	sname	count(*)
22	Dustin	2
31	Lubber	3
64	Horatio	2