Assignments+Semester+2


 * 26 Mar 15**
 * SQL Zoo Group Functions & Joins - Answer the questions, copy and paste answers into word (show me on your screen along with your quiz results)
 * [|Group Function Questions + Quiz]
 * [|Join Introduction + Quiz]


 * 21 January 15**
 * To Complete SQLZoo SELECT basics problems.
 * Go to this website
 * Open a new word document
 * Fix and submit the queries to the SQLZoo website
 * It will tell you when you get it right
 * Copy and Paste answers to word.
 * Save the word document
 * Show me the work when you're done on your screen


 * [[file:sec161.pdf|Sec 16.1]]
 * [[file:sec163.pdf|Sec 16.3]]
 * [[file:sec171.pdf|Sec 17.1]]
 * [[file:sec172.pdf|Sec 17.2]]
 * [[file:sec42.new.pdf|Sec4.2]]
 * [[file:db2.1.2.pdf|Sec 1.2]]

11 MAR 15
 * Too late to turn in:**
 * Look up MIN MAX SUM COUNT functions
 * Write defenitions in your own words for each
 * make a table of which ones you can use with which data types(strings/numbers/dates )
 * write a SELECT statement for each one using the cars or employees table

12 MAR 15
 * Some of these are harder to understand but we are going to clear that up on Monday
 * Look up CONCAT, INST, LENGTH, UPPER, LOWER, INITCAP, REPLACE, SUBSTR, TRIM, LPAD, RPAD
 * Write defenitions in your own words for each
 * make a table of which ones you can use with which data types(strings/numbers/dates )
 * write a SELECT statement for each one using the cars or employees table