EPAM Systems Interview Question

Practical questions 1. Sort an array without using inbuilt function 2. Write an SQL query to show product price and name from two tables product and line items and show only products whose price is greater than 150 USD?

Interview Answer

Anonymous

Feb 26, 2024

1. For sorting I write the code for quicksort and run it with the test case they have provided. It ran successfully after second attempt. 2. Select li.pid, p.pname, li.price From line_items as li JOIN products as p On p.id = li.pid Where li.price >150