Difference between revisions of "Introduction to Databases with Stanford University : Relational Algebra Exercises"

From Ittichai Chammavanijakul's Wiki
Jump to navigation Jump to search
(Created page with " 1. Find all pizzas eaten by at least one female over the age of 20. <pre> \project_{pizza} ( \select_{gender='female' and age > 20} Person \join Eats) </pre>")
 
Line 1: Line 1:
 +
Source: http://db-class.org
  
 
1. Find all pizzas eaten by at least one female over the age of 20.
 
1. Find all pizzas eaten by at least one female over the age of 20.

Revision as of 17:23, 16 November 2011

Source: http://db-class.org

1. Find all pizzas eaten by at least one female over the age of 20.

\project_{pizza} ( 
 \select_{gender='female' and age > 20} Person 
  \join Eats)