combining queries

example

• who won the java-jump event?
• want a table containing only the name of the winner
  so only column is CAFEMEISTER
  
• want to restrict rows so that EVENT is java-jump
• query:
  select CAFEMEISTER from
  
  filter EVENT = java-jump from
  EVENTS
• could do it the other way round too

other examples

• who sponsors alice?
• which athletes did more than 9 hours?
• whom does starbucks sponsor?

Previous slide

Next slide

Back to first slide

View graphic version