Lista de usuarios con colegio (last_login)

PHOTO EMBED

Fri May 28 2021 15:01:34 GMT+0000 (UTC)

Saved by @janicama #sql #postgres

select users.last_login,us.*,users.* from users left join user_school us on us.user_id = users.id where school_id is not null
and last_login between '2021-01-01'::date and '2021-12-31'::date
content_copyCOPY