Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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. roadStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started