SQL Queries for Employee Data Manipulation and Analysis

SELECT COUNT(DISTINCT job_title) AS num_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, CONCAT('$', LPAD(MIN(salary), 8, '0')) AS min_salary 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 FROM employees;

SELECT SUBSTRING_INDEX(job_title, ' ', 1) AS first_word 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), ' ', CONCAT('$', FORMAT(salary, 2))) AS name_salary FROM employees;