Changes between Version 6 and Version 7 of ImportantUseCase3


Ignore:
Timestamp:
01/21/22 22:26:18 (2 years ago)
Author:
191151
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ImportantUseCase3

    v6 v7  
    3737select u.full_name, u.email
    3838        from artists a
    39         join managers m on a.manager_id = m.user_id
    40         join users u on u.id = m.user_id
     39        join managers m
     40                on a.manager_id = m.user_id
     41        join users u
     42                on u.id = m.user_id
    4143        where
    42                 a.user_id = (select u.id from users u
    43                         where u.email = 'test_artist@mail.com')
     44                a.user_id = (
     45                        select u.id from users u
     46                        where u.email = 'test_artist@mail.com'
     47                );
    4448}}}
    4549