Different SQL Query to find Details

Question

Sir I need your help to find result in some sql quries. The questions regarding this table is been listed at the end. Please go through the questions and reply with the answers. Here the Sql Tables:- 1.tbl_Customer ------------ customerId numeric(180) customerName varchar(50) 2.tbl_Product ------------ productId numeric(180) productName varchar(50) 3.tbl_customerProductSales ------------------------ salesId numeric(180) salesAmount customerId numeric(180) productId numeric(180) 1) Add customerName and ProductName 2) Display second highest product rate and Name 3) Display highest product rate 4) Display top 3 product rate 5) Display lowest 3 product rate 6) Display CustomerName and having more than 5 sales 7) Display productName that not sold

Riddhi Valecha · Answer

1) Add customerName and ProductName - Insert Query 2) Display second highest product rate and Name - Select Query 3) Display highest product rate - Select Query 4) Display top 3 product rate - Select Query 5) Display lowest 3 product rate-Select Query 6) Display CustomerName and having more than 5 sales-Select Query 7) Display productName that not sold-Select Query.