Taboola Interview Question
8 sql questions,answer to last and most complicated questions
Interview Answer
Anonymous
Mar 30, 2022
SELECT p.name, sum (views) as total from views v inner join publishers p on CONVERT (VARCHAR (8000),v.publisher_name) = CONVERT (VARCHAR (8000),p.name ) where p.time_zone_name like '%eastern%' and v.date1 BETWEEN '01/01/2020' and '01/03/2022' group by p.name order by total desc.