Changes between Version 10 and Version 11 of UseCase4
- Timestamp:
- 01/21/22 20:37:20 (3 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UseCase4
v10 v11 44 44 45 45 {{{#!sql 46 select 47 b.business_id, 46 select 48 47 b.business_name, 49 48 ( 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, 57 53 c.category_name, 58 a.address_city,59 54 b.business_hours, 60 55 b.business_descr, 61 b.business_phone 56 b.business_phone 62 57 from 63 58 business b 64 59 join category c on 65 60 b.category_id = c.category_id 66 join address a on67 b.business_id = a.business_id68 61 where 69 b.business_id = 462 b.business_id = 5 70 63 }}} 71 64