regions countries locations REGION_ ID COUNTRY_ID COUNTRY_NAME VARCHAR2(40) CHAR(2) LOCATION_ID STREET ADDRESS VARCHAR2(25) NUMBER NUMBER REGION_NAME VARCHAR2(25) REGION_ID NUMBER POSTAL CODE...


The ER diagram of the database is given above.


Write the following queries.



1. Write a Query to get the First Name, Last Name and Salary of the employee who is paid the lowest salary in the company.


Hint: Use the employees table.


regions<br>countries<br>locations<br>REGION_ ID<br>COUNTRY_ID<br>COUNTRY_NAME VARCHAR2(40)<br>CHAR(2)<br>LOCATION_ID<br>STREET ADDRESS VARCHAR2(25)<br>NUMBER<br>NUMBER<br>REGION_NAME<br>VARCHAR2(25)<br>REGION_ID<br>NUMBER<br>POSTAL CODE<br>VARCHAR2(12)<br>CITY<br>VARCHAR2(30)<br>STATE PROVINCE VARCHAR2(12)<br>COUNTRY_ID<br>CHAR(2)<br>departments<br>employees<br>DEPARTMENT_ID<br>DEPARTMENT_NAME VARCHAR2(30)<br>NUMBER<br>YEMPLOYEE ID<br>NUMBER<br>FIRST NAME<br>LAST_NAME<br>VARCHAR2(20)<br>VARCHAR2(25)<br>VARCHAR2(25)<br>VARCHAR2(20)<br>jobs<br>MANAGER_ID<br>NUMBER<br>JOB_ID<br>LOCATION_ID<br>NUMBER<br>EMAIL<br>VARCHAR2(10)<br>PHONE_NUMBER<br>VARCHAR2(35)<br>MIN SALARY NUMBER<br>MAX_SALARY NUMBER<br>JOB_TITLE<br>HIRE DATE<br>DATE<br>JOB_ID<br>VARCHAR2(10)<br>SALARY<br>NUMBER<br>job_history<br>COMMISSION_PCT NUMBER<br>EMPLOYEE_ID<br>NUMBER<br>MANAGER_ID<br>DEPARTMENT_ID<br>NUMBER<br>YSTART DATE<br>job_grades<br>DATE<br>NUMBER<br>END DATE<br>DATE<br>GRADE LEVEL VARCHAR2(2)<br>LOWEST_SAL NUMBER<br>HIGHEST SAL KUMBER<br>JOB_ID<br>VARCHAR2(10)<br>00<br>DEPARTMENT_ID<br>NUMBER<br>

Extracted text: regions countries locations REGION_ ID COUNTRY_ID COUNTRY_NAME VARCHAR2(40) CHAR(2) LOCATION_ID STREET ADDRESS VARCHAR2(25) NUMBER NUMBER REGION_NAME VARCHAR2(25) REGION_ID NUMBER POSTAL CODE VARCHAR2(12) CITY VARCHAR2(30) STATE PROVINCE VARCHAR2(12) COUNTRY_ID CHAR(2) departments employees DEPARTMENT_ID DEPARTMENT_NAME VARCHAR2(30) NUMBER YEMPLOYEE ID NUMBER FIRST NAME LAST_NAME VARCHAR2(20) VARCHAR2(25) VARCHAR2(25) VARCHAR2(20) jobs MANAGER_ID NUMBER JOB_ID LOCATION_ID NUMBER EMAIL VARCHAR2(10) PHONE_NUMBER VARCHAR2(35) MIN SALARY NUMBER MAX_SALARY NUMBER JOB_TITLE HIRE DATE DATE JOB_ID VARCHAR2(10) SALARY NUMBER job_history COMMISSION_PCT NUMBER EMPLOYEE_ID NUMBER MANAGER_ID DEPARTMENT_ID NUMBER YSTART DATE job_grades DATE NUMBER END DATE DATE GRADE LEVEL VARCHAR2(2) LOWEST_SAL NUMBER HIGHEST SAL KUMBER JOB_ID VARCHAR2(10) 00 DEPARTMENT_ID NUMBER

Jun 03, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here