Module 5 Mastery Check

1. What does the following command return?

    SELECT ep_title AS Album, Band, IF(Release>1964 and Release<=1969, "60's"," ") AS Beatles Era, IF(Release>1979 and Release<1990, "New Wave"," ") AS "Hair Band Era", FROM RecordCollection ORDER BY Band; 

2. What is the purpose of the CASEWHEN function?

3. What are the four ways to control how a column of fields rounds off numeric content?

4. What does the code LPAD sale_price, 5, "$" return, when sale_price contains a string value of 9.95?

5. From a table called cust_orders that has the columns cust_num, design_num, design_name, quantity, and price, make a report that shows the total quantity of outfits bought by cust_num 13.

6. What would the following code return?

    concat_ws("   ", "There can be", "Only ONE") 

7. When is it required that you use the table_name.field_name syntax in your JOIN clause?

8. Can you use only the ORDER BY clause in the SELECT syntax?

9. Which function returns the current date and time on the computer on which you are working?

10. What does the following command do?

     SELECT Range, AVG(height) FROM Mountains GROUP BY Range HAVING Range="Rockies";