Write SQL Queries for the following: To display employee ids, names of employees, job ids with corresponding job titles.

Q. In a Database, there are two tables given below :

Write SQL Queries for the following :

(i) To display employee ids , names of employees, job ids with corresponding job titles.

(ii) To display names of employees, sales and corresponding job titles who have achieved sales more than 1300000.

(iii) To display names and corresponding job titles of those employees who have ‘SINGH’ (anywhere) in their names.

(iv) Identify foreign key in the table EMPLOYEE.

(v) Write SQL command to change the JOBID to 104 of the EMPLOYEE with ID as E4 in the table ‘EMPLOYEE’ .

Consider  this table --

You can understand by seeing this video ---

Answer = 

(i) SELECT EMPLOYEEID , NAME , EMPLOYEE.JOBID , JOBTITLE FROM EMPLOYEE  NATURAL JOIN ON JOB ;

(ii) SELECT NAME , SALES , JOBTITLE  FROM EMPLOYEE , JOB WHERE EMPLOYEE.JOBID = JOB.JOBID AND SALES > 1300000 ;

(iii) SELECT NAME , JOBTITLE FROM EMPLOYEE , JOB WHERE EMPLOYEE.JOBID = JOB.JOBID AND NAME LIKE “%SINGH%” ;

(iv) JOBID

(v) UPDATE EMPLOYEE SET JOBID = 104 WHERE EMPLOYEEID = "E4";