Advertisement
Guest User

Untitled

a guest
Apr 10th, 2020
288
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. UPDATE CONTRIBUTETO
  2. SET FEES = FEES + FEES * 0.01
  3. WHERE (PaperNum,RESEARCHER) ANY (
  4.   SELECT PaperNum,RESEARCHER
  5.   FROM CONTRIBUTETO, RESEARCHER, PAPER
  6.   WHERE CONTRIBUTETO.RESEARCHER = RESEARCHERID
  7.   AND CONTRIBUTETO.PAPERNUM = PAPER.PAPERNUM
  8.   AND CONFERENCELOCATION != 'KSA'
  9.   AND AFFILIATION = 'Government');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement