Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Dyspnoea.d, SUM(Dyspnoea.p*Either.p*Tuberculosis.p*Asia.p*p*Smoking.p*Bronchitis.p)
- --SELECT Dyspnoea.d, SUM(((Dyspnoea.p*Either.p*Tuberculosis.p*Asia.p)+(Dyspnoea.p*Either.p*LungCancer.p*Smoking.p)) + (Dyspnoea.p*Bronchitis.b*Smoking.p))
- SELECT Dyspnoea.d, SUM(Dyspnoea.p*Either.p*Tuberculosis.p*Asia.p*p*Smoking.p*Bronchitis.p)
- FROM Dyspnoea
- INNER JOIN Either ON Dyspnoea.e = Either.e
- INNER JOIN Tuberculosis ON Either.t = Tuberculosis.t
- INNER JOIN Asia ON Tuberculosis.a = Asia.a
- INNER JOIN LungCancer ON Either.l = LungCancer.l
- INNER JOIN Bronchitis ON Dyspnoea.b = Bronchitis.b
- INNER JOIN Smoking ON LungCancer.s = Smoking.s AND Bronchitis.s = Smoking.s
- WHERE Asia.a = 1 AND Smoking.s = 0
- GROUP BY Dyspnoea.d
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement