title: SQL group by day, with count
body: <p>I've got a log table in SQL Server that looks like this:</p>
  
  <pre><code>CREATE TABLE [dbo].[RefundProcessLog](
   [LogId] [bigint] IDENTITY(1,1) NOT NULL,
   [LogDate] [datetime] NOT NULL,
   [LogType] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
   [RefundId] [int] NULL,
   [RefundTypeId] [smallint] NULL,
   [LogMessage] [varchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
   [LoggedBy] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
   CONSTRAINT [PK_RefundProcessLog] PRIMARY KEY CLUSTERED 
  (
   [LogId] ASC
  ) ON [PRIMARY]
  ) ON [PRIMARY]
  
  GO
  </code></pre>
  
  <p>What I want is a list of results that represents how many different refundids were processed each day, throwing out any NULLs.</p>
  
  <p>What SQL would I need to write to produce these results?</p>