Changes between Version 6 and Version 7 of ImportantUseCase003

Timestamp:

12/28/22 14:19:17 (2 years ago)

Author:

201087

Comment:

--

ImportantUseCase003

@@ -39 +39 @@
 
 На студентот му се прикажуваат сите станови кои одговараат на внесените критериуми.
+
+[[Image(4.png)]]
+
+
+{{{
+select ime,prezime,phone_number,(p.price/p.number_of_roommates) as budget from appuser, student s,post p ,student_post sp  
+where (appuser.userid=s.studentid)
+and 
+(p.postid=sp.student_postid)
+and 
+(sp.studentid=s.studentid)
+and 
+(p.price<=400)
+and 
+(p.number_of_roommates=4);
+}}}