Subject - Fundamentals to DatabaseQuestion 5Based on the Table 5 and Table 6, write the SQL statement for the following cases in (5a), (5b), (5c), (5d) and (5e).Table 5: EmployeeEmployee_IdFirst_nameLast_nameSalaryJoining_DateDepartment1JohnAbraham100000001-Jan-13 12.00.00AMBanking2MichealClarke80000001-Jan-13 12.00.00AMInsurance3RoyThomas70000001-Feb-13 12.00.00AMBanking4TomJose60000001-Feb-13 12.00.00AMInsurance5JerryPinto65000001-Feb-13 12.00.00AMInsurance6PhilipMahtew75000001-Jan-13 12.00.00AMServices7TestName112365000001-Jan-13 12.00.00AMServices8TestName2Lname%60000001-Feb-13 12.00.00AMInsurance Table 6: IncetivesEmployee_ref_idIncentive_dateIncentive_amount101-Feb-135000301-Feb-133000401-Feb-134000501-Jan-134500601-Jan-133500 (d) Write the SQL code to get employee details from employee table whose first name ends with ‘n’ and name contain 4 letters. (e) Write the SQL code to get employee details from employee table whose joining year is “2013”.

Note:- you can use yyyy for 2013 and yy for 13. Use like operator to get names in pattern (name…

Answered: ubject - Fundamentals to Database…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

Subject - Fundamentals to Database

Question 5

Based on the Table 5 and Table 6, write the SQL statement for the following cases in (5a), (5b), (5c), (5d) and (5e).

Table 5: Employee

Employee_Id	First_name	Last_name	Salary	Joining_Date	Department
1	John	Abraham	1000000	01-Jan-13 12.00.00AM	Banking
2	Micheal	Clarke	800000	01-Jan-13 12.00.00AM	Insurance
3	Roy	Thomas	700000	01-Feb-13 12.00.00AM	Banking
4	Tom	Jose	600000	01-Feb-13 12.00.00AM	Insurance
5	Jerry	Pinto	650000	01-Feb-13 12.00.00AM	Insurance
6	Philip	Mahtew	750000	01-Jan-13 12.00.00AM	Services
7	TestName1	123	650000	01-Jan-13 12.00.00AM	Services
8	TestName2	Lname%	600000	01-Feb-13 12.00.00AM	Insurance

Table 6: Incetives

Employee_ref_id	Incentive_date	Incentive_amount
1	01-Feb-13	5000
3	01-Feb-13	3000
4	01-Feb-13	4000
5	01-Jan-13	4500
6	01-Jan-13	3500

(d) Write the SQL code to get employee details from employee table whose first name ends with ‘n’ and name contain 4 letters.

(e) Write the SQL code to get employee details from employee table whose joining year is “2013”.

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions