Changes between Version 11 and Version 12 of UseCase4

Timestamp:

01/21/22 20:38:25 (3 years ago)

Author:

193026

Comment:

--

UseCase4

@@ -60 +60 @@
         b.category_id = c.category_id
 where
-        b.business_id = 5
+        b.business_id = 4
 }}}
 
@@ -66 +66 @@
 
 {{{#!sql
-select s.service_name from business_service bs
+select
+        string_agg(s.service_name, '; ') as services
+from
+        business_service bs
 join service s on
         bs.service_id = s.service_id
-where business_id = 4 
+where business_id = 4
 }}}