Thanks for the reply
I tried the bellow queries
1) To get total product count
"select product,versionnumber,count(*) from net_productinfo group by product,versionnumber order by product"
2) To get availabile products
"select product,versionnumber,availability,count(*) from net_productinfo where...