Sams Teach Yourself SQL in 21 Days, Fourth Edition

Workshop

The Workshop provides quiz questions to help solidify your understanding of the material covered, as well as exercises to provide you with experience in using what you have learned. Try to answer the quiz and exercise questions before checking the answers in Appendix A, “Answers.”

Quiz

1:	With embedded functions, which function is resolved first, the innermost function or the outermost function?
2:	Are NULL values considered when an average of values in a column is calculated?
3:	When you convert bytes to megabytes, why do you divide by 1024 twice?
4:	What must you do to a value in a Character format before using the value in a calculation?

Exercises

1:	Using the emp_tbl table, write a SQL statement using MySQL that will return the following ...