Changes between Version 4 and Version 5 of UseCase3

Timestamp:

01/06/22 00:03:50 (3 years ago)

Author:

193026

Comment:

--

UseCase3

@@ -15 +15 @@
 [[Image(list.png, 746px)]]
 
+{{{#!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
+}}}
+
 Чекор 3 : Корисникот избира бизнис со кликнување на него.