ZS Associates SQL Questions and Answers

We noticed that in all SQL Questions of ZS Associates, the table used was same and just questions changed.

Check the table below and Solution Queries have already been provided.

Employee Table –

Employee_idFirst_nameLast_nameSalaryJoining_dateDepartment
1JohnAbraham100000001-JAN-13 12.00.00 AMBanking
2MichaelClarke80000001-JAN-13 12.00.00 AMInsurance
3RoyThomas70000001-FEB-13 12.00.00 AMBanking
4TomJose60000001-FEB-13 12.00.00 AM Insurance
5JerryPinto65000001-FEB-13 12.00.00 AMInsurance
6PhilipMathew75000001-JAN-13 12.00.00 AMServices
7TestName112365000001-JAN-13 12.00.00 AMServices
8TestName2Lname%60000001-FEB-13 12.00.00 AMInsurance

Incentive Table –

Employee_ref_idIncentive_dateIncentive_amount
101-FEB-135000
201-FEB-133000
301-FEB-134000
101-JAN-134500
201-JAN-133500

ZS SQL
ZS SQL 2