How to write query for conerting balls to overs in SQL?

Ramana Kopparapu 306

Hi,

Here is my input with number of balls and runs per each ball. I want to get output in the form of overs & total runs in SQL.

balls runs Overs Total Runs
1 3 2 25
2 1
3 0
4 6
5 0
6 2
1 4
2 3
3 3
4 0
5 1
6 2

Ramana Kopparapu 306 Reputation points

2022-11-04T11:53:15.463+00:00

Output will be like

Overs Runs
2 25
Olaf Helper 46,041 Reputation points

2022-11-04T11:53:36.55+00:00

Please post table design as DDL, some sample data as DML statement and the expected result.
What you posted as "result" is not readable and so not understandable.
Erland Sommarskog 117.1K Reputation points MVP

2022-11-04T22:40:38.73+00:00

For this type of question, we recommend that you post CREATE TABLE statements for your table(s) and INSERT statements with sample data. Furthermore, we need to get the expect result given the sample data. We also need a brief descriptions of the business rules so we know why you want that result.

You talk about balls, overs and runs, but I am afraid that I don't know what you are talking about. I guess it is a game or a sport, but please bear in that while we may know SQL well here, we may have very little knowledge about your business domain.
NikoXu-msft 1,916 Reputation points

2022-11-07T05:31:57.79+00:00

Hi @Ramana Kopparapu ,

While asking a question you need to provide a minimal reproducible example:
(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.
(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.
(3) Desired output based on the sample data in the #1 above.
(4) Your SQL Server version (SELECT @@version;)

Best regards
Niko
Olaf Helper 46,041 Reputation points

2022-11-07T06:26:53.107+00:00

Output will be like

And we still don't know the logic for the result; so please answer the questions.

Share via

How to write query for conerting balls to overs in SQL?

Your answer