tag:blogger.com,1999:blog-5005148102632656774.post2255595914612550184..comments2023-02-05T07:06:17.920-08:00Comments on Sybase Database Interview Questions and Answers: Q 11Sumedhhttp://www.blogger.com/profile/11533458660230230361noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5005148102632656774.post-65120682664963661202011-11-23T04:00:26.311-08:002011-11-23T04:00:26.311-08:00This comment has been removed by the author.Daniel Wielgórskihttps://www.blogger.com/profile/05191431000438292055noreply@blogger.comtag:blogger.com,1999:blog-5005148102632656774.post-37130864177887871042011-11-23T03:59:50.209-08:002011-11-23T03:59:50.209-08:001. To within two decimal digits, define the averag...1. To within two decimal digits, define the average amount of guns for the battleship classes.<br />Correct Query Bellow:<br />select CONVERT(decimal(10,2),round((sum(numguns)*1.00)/count(*),2)) from classes where type='bb'Daniel Wielgórskihttps://www.blogger.com/profile/05191431000438292055noreply@blogger.com