Question: Database using cmd. Solve this in 1 hour as soon as possible. REGIONS REGION 10 REGION_NAME DEPARTMENTS DEPARTMENT ID DEPARTMENT_NAME MANAGER D LOCATION D EMPLOYEES

 Database using cmd. Solve this in 1 hour as soon as

Database using cmd. Solve this in 1 hour as soon as possible.

REGIONS REGION 10 REGION_NAME DEPARTMENTS DEPARTMENT ID DEPARTMENT_NAME MANAGER D LOCATION D EMPLOYEES EMPLOYEE ID FIRST NAME LAST NAME COUNTRIES COUNTRY 10 COUNTRY NAME REGIONO JOBS JOD 10 JOB TITLE MIN_SALARY MAX_SALARY PHONE NUMBER HRE DATE JOB D SALARY COMMISSION PCT MANAGER O -DEPARTMENT_ID LOCATIONS JOB HISTORY LOCATION ID STREET ADDRESS POSTAL CODE CITY STATE_PROVINCE COUNTRY_ID EMPLOYEE 10 START-DATE END_DATE JOB ID DEPARTMENT_O 1. Write a query to find the all info of employees along with their manager_id and name (last_name). 2. Write a query to find the name (first_name, last_name), job, department ID and name of the employees who works in London. 3. Write a query to display the all information of all employees whose job is that of a Developer or a designer, and salary is not equal to $20,000, $45,000. 4. Display the manager id and the salary of the lowest and highest paid employee for that manager. 5. Display all job_id and job_title of all those jobs whose minimum salary is same. 6. SELECT from customers where salary>5000 7. Write a query to get the number of employees with the same job. 8. Show total number of locations in each region. Sort the result in ascending order of number of locations. 9. Write a SQL statement to find those salesmen with all information who come from the city either Paris or Rome. salesman_id ! commission 1 city 5081 Dames Hoog New York 0.15 5002 Nail knite | Paris 0.13 5005 Pit Alex London 1 8.11 5006 Mc Lyon Paris 1 0.14 5087 Paul Adan Rome 1 8.13 5003 Lauson Hen San Jose . 12 10. Show manager name for all departments (department name). If no manager is working, then represent it with NULL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!