I've spent the last six hours or so on this:
1. Write one query that uses a function from each of the following functional types:I did about twice as much work as the assignment called for because it was Just! So! FUN! Every time a query worked I got to do a little happy dance, and the hours just flew by! I was so mad when my computer ran out of battery juice and shut down while I was in the middle of a query and I lost some of my work. But then I was happy because it meant I got to do it again!
1. String functions
2. Mathematical functions
3. Date functions
4. Grouping functions (aggregate functions)
2. Write two SQL statements that use joins, either INNER or OUTER joins as you choose. Include a description of what each SQL statement is doing, and what the results of each SQL statement should be.
I definitely need to think about getting some kind of therapy.
The song du jour of the day, therefore, is the Jesus and Mary Chain's Halfway to Crazy, even though I think I passed the halfway mark some time ago.