SQL Queries for Employee Data Manipulation and Analysis

SELECT COUNT(DISTINCT job_title) AS number_of_designations FROM employees;

SELECT job_id, employee_id FROM employees;

UPDATE employees SET phone_number = REPLACE(phone_number, '124', '999');

SELECT * FROM employees WHERE LENGTH(first_name) >= 8;

SELECT CONCAT('$', LPAD(MAX(salary), 8, '0')) AS max_salary_with_zeros, CONCAT('$', LPAD(MIN(salary), 8, '0')) AS min_salary_with_zeros FROM employees;

SELECT employee_id, SUBSTRING(email, 1, LENGTH(email)-3) AS email_id FROM employees;

SELECT SUBSTRING_INDEX(street_address, ' ', -1) AS last_word_of_address FROM employees;

SELECT SUBSTRING_INDEX(job_title, ' ', 1) AS first_word_of_job_title FROM employees WHERE job_title LIKE '% %';

SELECT LENGTH(first_name) AS first_name_length FROM employees WHERE last_name LIKE '__c%';

SELECT CONCAT(LEFT(first_name, 8), ' $', salary, ' ') AS first_name_and_salary FROM employees;