Changes between Version 8 and Version 9 of UseCase3

Timestamp:

01/21/22 21:00:49 (3 years ago)

Author:

193026

Comment:

--

UseCase3

@@ -17 +17 @@
 {{{#!sql
 select
-                                b.business_id,
-                                b.business_name,
-                                (
-                                        select avg(r.review_stars)
-                                        from review r
-                                        where r.business_id = b.business_id
+        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
+        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
+from
+        business b
+join category c on
+        b.category_id = c.category_id
+order by
+        b.business_name
 }}}