What is the lambing rate and litter size of females with a first mating at 0, 6, 12 and 18 hours after onset of estrus, by month of year between 1997 and 2002? Also sows must have >1 mating/service. Does the time of year have an affect on the length of a female's heat and duration of ovulation? Does waiting to inseminate hurt reproductive performance at different times of the year?
Using the Query report designer, enter the following SQL statement:
SELECT
EXTRACT(MONTH FROM SERVDATE) AS N_MONTH,
SERVHOUR1,
COUNT(*) AS SERVICES,
SUM(SERVBIRTHING) AS BIRTHINGS,
AVG(100.0*SERVBIRTHING) AS RATE,
SUM(TOTALBORN) AS TOTALBORN,
AVG(1.00*TOTALBORN) AS AVG_TOTALBORN
FROM SERVICERESULT
WHERE MATINGS>1
AND SERVDATE BETWEEN '1997 JAN 01' AND '2002 DEC 31'
GROUP BY EXTRACT(MONTH FROM SERVDATE),
SERVHOUR1
ORDER BY EXTRACT(MONTH FROM SERVDATE),
SERVHOUR1
The Query report is shown below:
