Consider the following relational schemaemployee (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 greaterthan Tk.100,000. In such cases, give only a 3 percent raise.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here