==  Приказ на детали
 Посетител или Reviewer може да гледа детали за избраниот бизнис.

=== Актери
 * Посетител
 * Reviewer

=== Реализација
Чекор 1 : Системот го прикажува избраниот бизнис.

[[Image(biznis.2.png, 959px)]]

''Најди детали за бизнисот''

{{{#!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,
	b.business_hours,
	b.business_descr,
	b.business_phone	
from
	business b
join category c on
	b.category_id = c.category_id
join address a on
	b.business_id = a.business_id
where
	b.business_id = 4
}}}

''Најди ги сите сервиси за бизнисот''

{{{#!sql
select s.service_name from business_service bs
join service s on
	bs.service_id = s.service_id
where business_id = 4 
}}}

{{{#!sql
select
	r.reviewer_name,
	r.reviewer_verified,
	review.review_title,
	review.review_text,
	review.review_stars
from
	review
join reviewer r 
on
	review.reviewer_id = r.reviewer_id
where
	review.business_id = 4;
}}}