Consider the following relational schema employee (ename, street, city) works (ename, cname, salary, jdate) company (cname, city) manages (ename, mname) Write down the following queries in SQL 1. Find...


Consider the following relational schema
employee (ename, street, city)
works (ename, cname, salary, jdate)
company (cname, city)
manages (ename, mname)
Write down the following queries in SQL


1. Find the names of all employees who earn more than every employee of Square Pharma.


2. Give all managers in this database a 4 percent salary raise, unless the salary would be greater
than Tk.100,000. In such cases, give only a 3 percent raise.



Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here