HW1 on Relational Algebra and Basic SQL
HW is due 10/29 at 1:30 pm. All sections assume 6th edition of book.
Read: - 18.104.22.168 (Assignment Operator) - 22.214.171.124 (Aggregation Operator)
Exercises from book:
Basic SQL Exercises:
On SQL please: - use bold or UPPERCASE for keywords (i.e. SELECT FROM WHERE AVG) - use a newline after major keyword line (ie select from where groupby)
WHERE age=22 AND state = 'IL'