Ivalua interview question
1. Codility test was easy - required basic joins, group by, order by, union all, case and cte usage 2. In the virtual interview with Integration lead , no questions were asked regarding background or my work but only one basic sql question to write sql query to make a report and was given two table with no common column
Interview Answer
Anonymous
-- SOLUTION 1 -- Using COMMMA JOIN -- select case when Grade.grade<8 then NULL else student.name end as Name, Grade.grade Grade, student.marks as Mark from student, grade where student.marks between grade.min_mark and grade.max_mark order by grade desc, marks; -- SOLUTION 2 -- Using INNER JOIN -- select case when Grade.grade<8 then NULL else student.name end as Name, Grade.grade Grade, student.marks as Mark from student inner join grade on student.marks between grade.min_mark and grade.max_mark order by grade desc, marks;