Count() by date range

• Redmond01

  SSC-Addicted

  Points: 492

  More actions

  September 22, 2010 at 11:14 pm

  #98905

  a. tblMen

  i. ManId (Int) – Primary Key

  ii. TestDate (Datetime) – The date that the person has taken the test.

  iii. Score (int) – The test score

  b. tblWomen

  i. WomanId (Int) – Primary Key

  ii. TestDate (Datetime) – The date that the person has taken the test.

  iii. Score (int) – The test score

  Write a SQL query that returns two columns:

  a. Week Starting Date, starting from the first Sunday of 2010 in the format MM/DD/YYYY

  b. Total count of men and women that took the test that week.

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  September 23, 2010 at 1:21 am

  #1226118

  Sound straight forward enough if you use a calendar table.

  Can you show us your code so far ?

  ---

  
  Clear Sky SQL
  My Blog[/url]