This preview shows page 1. Sign up to view the full content.
Unformatted text preview: DAYOFMONTH(birthdate) = 14 use numbers so 14 would signify the fourteenth day of the month YEAR(NOW())-YEAR(birthdate) AS age Will take current year (i.e. 2007) and subtract from birth year to calculate an age Other Functions usually used together: (all these will be introduced on Thursday) MIN(DigitalFilesize) AS smallest Will give the minimum filesize found COUNT(SecondaryArtistID) AS NumberofSecondaryArtists Will calculate how many SecondaryArtistID records have been filled in AVG(DigitalFilesize) AS AverageSize Will calculate the average size of the files MAX(DigitalFilesize) AS largest Will give the maximum filesize found...
View Full Document
- Spring '08