Question: Using the tables above, write and execute SQL for the following queries. Save each successful command in the spool file. q:List employees whose surnames begin

 Using the tables above, write and execute SQL for the following

queries. Save each successful command in the spool file. q:List employees whose

surnames begin with S and whose employee ids begin with either E1

Using the tables above, write and execute SQL for the following queries. Save each successful command in the spool file.

q:List employees whose surnames begin with S and whose employee ids begin with either E1 or E3 along with the departments in which they work. The result listing should include the ids, names of the employees and the names of their departments.

"Employee" DATABASE SCHEMA Employee (emp_id, name, address, DOB, job, salary, dpt_ id, manager, scheme) Department (depart_code, name) Salary Grade (salary_code, start_salary, finish_salary) Pension_Scheme (scheme_id, name, rate) TABLE: Employee emp_ name address DOB job id E101 Sender, 1 high06/03/76Clerk salary dpt id manager scheme S1 D10 E110 S116 street E301 Ali, 11/04/80 Sales S2 D30 E310 S124 F. railway person road E310 Flavel, 14 25/11/69 Manager S5 D30 S121 crescent E501 Carlos, 7 heap 09/02/72Analyst S5 E102 Sayer, 16 glade 13/07/74Clerk E110 Tojo, 199 road street close London D50 D10 D10 S121 S116 S121 S1 E110 22/05/70Manager S5 B. road

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!