Changes between Version 11 and Version 12 of ImportantUseCase001

Timestamp:

12/27/22 19:27:29 (2 years ago)

Author:

201144

Comment:

--

ImportantUseCase001

@@ -57 +57 @@
 
 
+{{{
+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);
+}}}
 
 
 
 
+