/* Query 13 (page 137, 227 of the text book)

   Show the resulting salaries if every employee working on the 'ProductX' project is
   given a 10 percent raise.

   The result must be
	'Joyce'	'English'	27500
	'John'	'Smith'	33000
*/

  select fname, lname, (1.1 * salary) as increasedSalary
  from employee e, works_on w, project p
  where e.ssn = w.essn and w.pno = p.pnumber and pname = 'ProductX' ;


