Changes between Version 6 and Version 7 of ImportantUseCase012

Timestamp:

01/11/25 20:59:59 (4 days ago)

Author:

201205

Comment:

--

ImportantUseCase012

@@ -28 +28 @@
 
 {{{
-SELECT B.Title, B.Author, B.Language, B.ImageURL, U.Username, U.City, U.Neighborhood, L.Condition, G.Genre
-FROM Book B JOIN Library L ON B.BookId=L.BookId
-        JOIN USER U ON L.UserId=U.UserId
-        JOIN GENRE G ON B.BookId=G.BookId
-WHERE LOWER(B.Title) LIKE ('%search%') OR LOWER(B.Author) LIKE ('%search%') OR LOWER(G.Genre) LIKE ('%search%')
-
+select b.title, b.author, b.language, b.imageurl, l.condition, u.username, u.city, u.neighborhood, g.genre
+from book b join library l on b.bookid=l.bookid 
+        join appuser u on l.userid=u.userid
+        left join genre g on g.bookid=b.bookid
+where lower(b.title) like ('%search%')
+order by u.city, u.neighborhood;
 
 }}}