Changes between Version 7 and Version 8 of UseCase3

Timestamp:

01/21/22 20:42:19 (3 years ago)

Author:

193026

Comment:

--

UseCase3

@@ -16 +16 @@
 
 {{{#!sql
-select 
-        b.business_id,
-        b.business_name,
-        (
-        select
-                avg(r.review_stars)
-        from
-                review r
-        where
-                r.business_id = b.business_id 
-) as business_avg_stars,
-        c.category_name,
-        a.address_city
-from
-        business b
-join category c on
-        b.category_id = c.category_id
-join address a on
-        b.business_id = a.business_id
+select
+                                b.business_id,
+                                b.business_name,
+                                (
+                                        select avg(r.review_stars)
+                                        from review r
+                                        where r.business_id = b.business_id
+                                ) as business_avg_stars,
+                                c.category_id,
+                                c.category_name,
+                                (
+                                        select string_agg(a.address_city, '; ') as address_city
+                                        from address a
+                                        where a.business_id = b.business_id
+                                ) as address_city
+                        from business b
+                        join category c on
+                                b.category_id = c.category_id
+                        order by b.business_name
 }}}