Advertisement
Guest User

Untitled

a guest
Dec 5th, 2016
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. Consider a relation of scheme Building(Street, Number, No.Apartments, Color, Age).
  2. TRC: find the oldest building in Downing Street.
  3.  
  4. SELECT MAX(Age) AS ‘Oldest building’, Street FROM Building WHERE Street = ‘Downing Street’;
  5.  
  6. {V.*|V(B) | V.BAge >=Age ^ V.Bstreet = ‘Downing Street’}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement