Advertisement
Guest User

Untitled

a guest
Apr 10th, 2020
183
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,CONTRIBUTETO.RESEARCHER
  5.   FROM CONTRIBUTETO, RESEARCHER, PAPER
  6.   WHERE CONTRIBUTETYPE = 'First'
  7.   AND CONTRIBUTETO.RESEARCHER = RESEARCHERID
  8.   AND CONTRIBUTETO.PAPERNUM = PAPER.PAPERNUM
  9.   AND NOT  CONFERENCELOCATION  = 'KSA'
  10.   AND AFFILIATION = 'Government');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement