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?
Anonymous
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
Check out your Company Bowl for anonymous work chats.