Advertisement
Guest User

Untitled

a guest
May 2nd, 2016
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. FROM FactPerson FP
  2. JOIN FactCrash FC ON FP.CrashSK = FC.CrashPK
  3. JOIN DimHWYType DHT ON DHT.HWYTypeCode = FC.HighwayTypeCode
  4. JOIN FactVehicle FV ON FV.CrashSK = FC.CrashPK
  5. JOIN DimVehicleType DVT ON DVT.VehicleTypeCode = FV.VehicleTypeCode
  6. WHERE (FC.HighwayTypeCode = 'A' OR FC.HighwayTypeCode = 'B' OR FC.HighwayTypeCode = 'C')
  7. AND (FV.VehicleTypeCode = 'A' OR FV.VehicleTypeCode = 'B' OR FV.VehicleTypeCode = 'S')
  8. AND (FP.Age, FP.PersonType) IN
  9. (SELECT FP.Age, FP.PersonType
  10. FROM FactPerson FP
  11. WHERE (FP.PersonType = 'A')
  12. AND (FP.Age BETWEEN 18 AND 21))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement