1. Write the Query to fetch the data for the below conditions. [No Need to create table or insert records or show any results in workbench, just write the queries that will get the result for below conditions]

    

   1. Display the Joining_Date and First_Name associated with Job_Role = 'In charge'
   2. Display the First_Name, Last_Name, Job_Role associated with Joining_Date = '2016/04/18'

2. 

   
   

   
   

   1.  

Transcribed Image Text:

Joins: Consider the table-- Employee with the following data Job Role Emp_Id Last Name First Name E0011 Verma Akhil Administration E0012 Samson Nikita Asst. Manager E0013 Jordan Nil In charge E0014 Smith Joe Technician The second Table is Company Emp_ld Last Name First Name Joining Date E0012 Verma Akhil 2016/04/18 E0013 Samson Nikita 2016/04/19 E0014 Jordan Nil 2016/05/01 Joins: Consider the table-- Employee with the following data Job Role Emp_Id Last Name First Name E0011 Verma Akhil Administration E0012 Samson Nikita Asst. Manager E0013 Jordan Nil In charge E0014 Smith Joe Technician The second Table is Company Emp_ld Last Name First Name Joining Date E0012 Verma Akhil 2016/04/18 E0013 Samson Nikita 2016/04/19 E0014 Jordan Nil 2016/05/01