November 13, 2019

Wednesday of Week 12

Topic of the day

| Reading | Online | Questions | Assignments | Photos |

Suggested readings

Online references

Questions and exercises

  1. What part of a SELECT statement controls the columns that will be produced in the result? What part controls which rows will be filtered into the result?
  2. Give an example SQL statement that shows how GROUP BY is used to aggregate information (with summary statistics).
  3. What is the difference between WHERE clauses and HAVING clauses in an SQL SELECT statement?
  4. What does it mean to "join" two tables? What makes something a "natural" join (as opposed to some other kind of join)?

Assignments

Today

Upcoming

Board photo