Changes between Version 10 and Version 11 of UseCase4


Ignore:
Timestamp:
01/21/22 20:37:20 (3 years ago)
Author:
193026
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UseCase4

    v10 v11  
    4444
    4545{{{#!sql
    46 select
    47         b.business_id,
     46select
    4847        b.business_name,
    4948        (
    50         select
    51                 avg(r.review_stars)
    52         from
    53                 review r
    54         where
    55                 r.business_id = b.business_id
    56 ) as business_avg_stars,
     49                select avg(r.review_stars)
     50                from review r
     51                where r.business_id = b.business_id
     52        ) as business_avg_stars,
    5753        c.category_name,
    58         a.address_city,
    5954        b.business_hours,
    6055        b.business_descr,
    61         b.business_phone       
     56        b.business_phone
    6257from
    6358        business b
    6459join category c on
    6560        b.category_id = c.category_id
    66 join address a on
    67         b.business_id = a.business_id
    6861where
    69         b.business_id = 4
     62        b.business_id = 5
    7063}}}
    7164