Data Analyst | June 2020
Position: Data Analyst
Level: Associate/Entry Level
Outcome: Techncal Screen Rejected
How was the interview process? What was it like?
What technical questions were asked?
SQL / Analytics
What was one of your solutions?
DATE(t.login) AS day,
d.name AS department_name,
SUM(DATE_PART('hour', t.logout - t.login)) AS total_hours
department d ON t.department_id = d.id
GROUP BY 1 , 2
order by day asc;