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(18,0)

customerName varchar(50)



2.tbl_Product
------------

productId numeric(18,0)

productName varchar(50)


3.tbl_customerProductSales
------------------------

salesId numeric(18,0)

salesAmount

customerId numeric(18,0)

productId numeric(18,0)




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