use isubeefdb;

/* select Intl_ID from GeneticsPlatformData where PedID='' OR PedID is null; */

/* ISU(Y|N) = 'Y' cattle that do not have a farm location
select BirthDate,Intl_ID from Pedigree where ISU='Y' AND PedID NOT in (select PedID from Location_track) order by 1;
*/

/* Animals missing birth dates */
select BirthDate,Intl_ID from Pedigree where BirthDate is NULL OR BirthDate='';