ITM 500 Lecture 3: Lab Week 3

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 500
• Professor: Nurul Huda

Document Summary

List the details for all tournaments that have the characters coast anywhere in. - tournament name select * from tournament where tourname like "%coast%" -2 list the details for all members whose phone number ends with a 4 select * from member where phone like "%4" List the details for all members whose phone number"s 4th digit is a 4 select * from member where phone like "___4%" List the details for all members that joined after the end of february 2007 select * from member where joindate>"2007-02-20" List the details for all members that joined in 2001 select * from member where joindate>="2001" and joindate<="2002" Count the total number of male members select count(gender) as malemember from member where gender = "m" malemember. Count the number of different teams that male members play on select distinct teamname from member where gender = "m"