Notes

-- @E:18408446db2week1318408446_more_functions.txt

--showing companies structure
DESC companies;

--showing training budget of all companies
SELECT training_budget FROM companies;

--copying from doc file
UPDATE companies
SET training_budget = training_budget+(training_budget * 0.17867865);

-- showing ceil, floor, round and trunc values of training_budget
SELECT CEIL(training_budget)Ceil,FLOOR(training_budget)Floor,ROUND(training_budget,2)Round,trunc(training_budget,2)Trunc
FROM companies;

-- showing ceil, floor, round and trunc values of training_budget including MAX
SELECT MAX(CEIL(training_budget))Ceil,MAX(FLOOR(training_budget))Floor,MAX(ROUND(training_budget,2))Round,MAX(trunc(training_budget,2))Trunc
FROM companies;

-- showing good morning along with username based on the first 2 letters of the firstname, the first 5 letters of the surname of students
SELECT CONCAT('Good Morning ',CONCAT(SUBSTR(student_firstname,1,2),SUBSTR(student_surname,1,5))) Username
FROM students;

-- (lowercase) showing good morning along with username based on the first 2 letters of the firstname, the first 5 letters of the surname of students
SELECT LOWER(CONCAT(SUBSTR(student_firstname,1,2),SUBSTR(student_surname,1,5))) Username
FROM students;

-- (lowercase) showing good morning along with username based on the first 2 letters of the firstname, the first 5 letters of the surname of students
SELECT CONCAT(SUBSTR(TRIM(TRAILING ' ' FROM INITCAP(student_firstname)),1,2),SUBSTR(INITCAP(student_surname),1,5)) Username
FROM students;

--Bonus Activity
-- showing company name a along with training_budget
SELECT company_name, CEIL(training_budget)Ceil,FLOOR(training_budget)Floor,ROUND(training_budget,2)Round,trunc(training_budget,2)Trunc
FROM companies
WHERE training_budget =
(SELECT MAX(training_budget) FROM companies);