Intermission Work Tracker

	B	C	D	E	F	G
1
2	PostgreSQL Exercises
3	Make a copy of this Tracker - Send a link to your copy to your instructors when you have finished!
4
5	Required
6	Basic	Solution	Needed Hint	Needed Solution	Completed On	Notes
7	Retrieve everything from a table
8	Retrieve specific columns from a table
9	Control which rows are retrieved
10	Basic string searches
11	Working with dates
12	Removing duplicates, and ordering results
13	Simple aggregation
14	More aggregation
15	Joins	Solution	Needed Hint	Needed Solution	Completed On	Notes
16	Retrieve the start times of members' bookings
17	Work out the start times of bookings for tennis courts
18	Produce a list of all members who have used a tennis court
19	Modifying Data	Solution	Needed Hint	Needed Solution	Completed On	Notes
20	Insert some data into a table
21	Insert multiple rows of data into a table
22	Update some existing data
23	Update multiple rows and columns at the same time
24	Delete all bookings
25	Delete a member from the cd.members table
26	Aggregation	Solution	Needed Hint	Needed Solution	Completed On	Notes
27	Count the number of facilities
28	Count the number of expensive facilities
29	List the total slots booked per facility
30	Find the count of members who have made at least one booking
31	Output the facility id that has the highest number of slots booked
32
33	Recommended
34	Basic	Solution	Needed Hint	Needed Solution	Completed On	Notes
35	Control which rows are retrieved - part 2
36	Matching against multiple possible values
37	Classify results into buckets
38	Joins	Solution	Needed Hint	Needed Solution	Completed On	Notes
39	Produce a list of all members who have recommended another member
40	Produce a list of all members, along with their recommender
41	Produce a list of costly bookings
42	Modifying Data	Solution	Needed Hint	Needed Solution	Completed On	Notes
43	Update a row based on the contents of another row
44	Delete based on a subquery
45	Aggregation	Solution	Needed Hint	Needed Solution	Completed On	Notes
46	Count the number of recommendations each member makes.
47	List the total slots booked per facility in a given month
48	List the total slots booked per facility per month
49	List facilities with more than 1000 slots booked
50	Find the total revenue of each facility
51	Find facilities with a total revenue less than 1000
52	List the total slots booked per facility per month, part 2
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100