StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to write a query with an average column in SQL Server Management Studio
primarykey
Id
6292159
data
AcceptedAnswerId
6292210
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-06-09T11:35:58.013
FavoriteCount
0
LastActivityDate
2011-06-09T11:41:01.033
LastEditDate
2011-06-09T11:38:47.367
LastEditorUserId
13302
OwnerUserId
779639
ParentId
0
PostTypeId
1
Score
0
ViewCount
309
LastEditorDisplayName
text
Body
<p>I would like to know if I can add an average column to this script whereby it averages the total number of inspections by the number of days. At the moment this report is showing 5 days worth of inspections. so I need the <code>averageinspection</code> column to divide the <code>totalinspection</code> by 5. is this possible?</p> <pre><code>SELECT EstimName_String AS Inspector, InspectionProcedureName AS inspection, COUNT(*) AS TotalInspections FROM UnitData_Vehicle WHERE DATEDIFF(day, InspectionDateTime, GETDATE()) = 1 GROUP BY InspectionProcedureName, EstimName_String </code></pre> <p>I would like to show this:</p> <pre><code>Inspector Inspection Totalinspections Averageinspections Joe Bloggs Inspection 20 4 Micky Mouse Inspection 100 20 Jack and Jill Inspection 50 10 </code></pre>
Tags
<sql><sql-server-2005><count><average>
Title
How to write a query with an average column in SQL Server Management Studio
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USmarc_s
UserOwnerUserId
1. USTyrone2011
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COWhere does 5 come from, when DATEDIFF is looking for "1"?
  singulars
  PostPostId
  POHow to write a query with an average column in SQL Server Management Studio
  UserUserId
  USgbn

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.