We started with this: Gerry's handwritten notes.

Each piece of data forms a record, so in the case of my project, each day is a record of our scores, the date, and the solved word. When I submit the new record each day, -- and here is the beauty of a database and SQL ---there is an SQL statement that does a whole lot of updating in the background. Over 100 lines of instructions.

• insert today's results
• drop, then recreate a table with current month's data
• drop and recreate table with Totals
• add column with the Best result ie Min(totals)
• if statement to add "Leader" to the Best person.
• drop and recreate the "wordsused" table
• insert the Letter value(a,b,c...) to make the table more reader friendly.
• add the column to show individual scores
• populate the scores columns
• Drop and recreate the wordcount table insert into wordcount select 'a',count(word) as wdcount from wordsUsed where word like 'a%' and length(word) > 2;

So this all starts with updating one record and becomes a whole package of useful information, nicely presented by Stacks.