Exercise for Tuesday, October 29

Work with your classmates. Divide this work amongst yourselves.

• Learn how to use some of MySQL's date and time functions. Write code that shows us how to use these functions.
• Learn how to use some of MySQL's string functions. Write code that shows us how to use these functions.
• Learn how to use some of MySQL's mathematical functions. Write code that shows us how to use these functions.
• Learn how to use SQL's HAVING clause. Write code that shows us how to use this feature of the language.
• Learn how to use MySQL's ROLLUP clause. Write code that shows us how to use this feature of the language.
• Learn how to use SQL's LIKE condition. Write code that shows us how to use this feature of the language.
• Learn how to use SQL's IN clause. Write code that shows us how to use this feature of the language.