CODEWITHSUNDEEP
sqlsql-server
Blair Kennedy
Blair Kennedy

Reputation: 3

Create new column by dividing two columns in SQL Server query

I have this query set up in SQL Server:

Select [Month]
  ,[Users]
  ,[Shows]
  ,[Clicks]
  ,[Orders]
  ,[Sales_Revenue]
From [dbo].[Perf]
Where Sales_Revenue > 5000000

I want from this query to also include a command where I divide Sales_Rev by Orders and create an Average Order column.

Upvotes: 0

Views: 939

Answers (2)

Bharathi
Bharathi

Reputation: 1015

If you want to handle 'Divide By Zero' error when your Orders = 0, use NULLIF

Select [Month]
  ,[Users]
  ,[Shows]
  ,[Clicks]
  ,[Orders]
  ,[Sales_Revenue]
 ,[Sales_Revenue]/NULLIF([Orders],0) AS 'Average Order'
From [dbo].[Perf]
Where Sales_Revenue > 5000000

Upvotes: 1

Buchiman
Buchiman

Reputation: 320

Just add [Sales_Revenue]/[Orders] as Average Order in your select query.

Select [Month]
  ,[Users]
  ,[Shows]
  ,[Clicks]
  ,[Orders]
  ,[Sales_Revenue]
  ,[Sales_Revenue]/[Orders] AS [Average Order]
From [dbo].[Perf]
Where Sales_Revenue > 5000000

Upvotes: 0

Related Questions