Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- FROM FactPerson FP
- JOIN FactCrash FC ON FP.CrashSK = FC.CrashPK
- JOIN DimHWYType DHT ON DHT.HWYTypeCode = FC.HighwayTypeCode
- JOIN FactVehicle FV ON FV.CrashSK = FC.CrashPK
- JOIN DimVehicleType DVT ON DVT.VehicleTypeCode = FV.VehicleTypeCode
- WHERE (FC.HighwayTypeCode = 'A' OR FC.HighwayTypeCode = 'B' OR FC.HighwayTypeCode = 'C')
- AND (FV.VehicleTypeCode = 'A' OR FV.VehicleTypeCode = 'B' OR FV.VehicleTypeCode = 'S')
- AND (FP.Age, FP.PersonType) IN
- (SELECT FP.Age, FP.PersonType
- FROM FactPerson FP
- WHERE (FP.PersonType = 'A')
- AND (FP.Age BETWEEN 18 AND 21))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement