QotD Questions Archive – Page 505 of 547

Blogs

Index maintenance has always meant nightly jobs and a window you have to defend....

I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...

One of the things I’ve been requesting for a number of years is cost...

Comments posted to this topic are about the item SQL Art, Part 4: Happy...

WA:083178278662 Darmo Park, Komp, Jl. Mayjen Sungkono I No.4-6, Darmo, Kec. Wonokromo, Surabaya, Jawa...

WA:083178278662 Jl. Kalimantan No.14, Gubeng, Kec. Gubeng, Surabaya, Jawa Timur 60281

I have this data in the dbo.Commission table in a SQL Server 2022 database.

salesperson commission
Brian       12
Brian       16
Andy        7
Andy        14
Andy        21
Steve       20
Steve       NULL

All the data is a varchar, and I decide to run this query to get the totals for each salesperson.

SELECT SalesPerson
     , AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
 FROM commission
 GROUP BY SalesPerson
GO

What average commission is calculated for Steve?