From 023919ac8515fb9aa9e7663a9a9321cea5493584 Mon Sep 17 00:00:00 2001
From: Ardis Lu <ardisglu@gmail.com>
Date: Sun, 29 Aug 2021 02:01:13 -0700
Subject: [PATCH] Update example SQL query to match updated database

---
 demo/index.html | 15 ++++++++++++++-
 1 file changed, 14 insertions(+), 1 deletion(-)

diff --git a/demo/index.html b/demo/index.html
index 76e30f7..492d380 100644
--- a/demo/index.html
+++ b/demo/index.html
@@ -78,7 +78,20 @@
 
   <main>
     <label for="editor">Enter a SQL query:</label>
-    <textarea id="editor" name="editor">SELECT state, COUNT(id), AVG(number_column_1) FROM table_1 GROUP BY state</textarea>
+    <textarea id="editor" name="editor">
+    SELECT
+      users.first_name
+      , users.last_name
+      , STRFTIME('%Y-%m-%d', users.birthday) AS BIRTHDAY
+      , transactions.category
+      , SUM(transactions.price) AS TOTAL
+    FROM
+      users
+      INNER JOIN transactions ON users.user_id = transactions.user_id
+    GROUP BY
+      users.user_id
+      , transactions.category
+    </textarea>
     <button id="execute">Execute SQL</button>
 
     <table id="output">
-- 
2.47.3