Changes between Version 6 and Version 7 of ImportantUseCase3

Timestamp:

01/21/22 22:26:18 (3 years ago)

Author:

191151

Comment:

--

ImportantUseCase3

@@ -37 +37 @@
 select u.full_name, u.email 
         from artists a
-        join managers m on a.manager_id = m.user_id 
-        join users u on u.id = m.user_id 
+        join managers m 
+                on a.manager_id = m.user_id 
+        join users u 
+                on u.id = m.user_id 
         where 
-                a.user_id = (select u.id from users u
-                        where u.email = 'test_artist@mail.com')
+                a.user_id = (
+                        select u.id from users u
+                        where u.email = 'test_artist@mail.com'
+                );
 }}}