Notes

--describing companies
DESC companies;
--training_budget column allows (10,2). Two digits after decimal

--querying training_bugdet in companies table
SELECT training_budget FROM companies;

--updating training_budget colum of companies table
UPDATE companies
SET training_budget = training_budget+(training_budget * 0.17867865);

--this statement update all the training_budget column in table

--querying training_budget after updated from companies table
SELECT training_budget FROM companies;
--datas updated

--using ceil,floor,round and trunc in one statement
SELECT training_budget,
CEIL(training_budget) "CEILED VALUE",
FLOOR(training_budget) "FLOORED",
ROUND(training_budget) ROUNDED,
TRUNC(training_budget) TRUNCATED
FROM companies;
--7 rows returned

--using MAX function to amend above query
SELECT MAX(training_budget),
CEIL(MAX(training_budget)) CEILED,
FLOOR(MAX(training_budget)) FLOORED,
ROUND(MAX(training_budget)) ROUNDED,
TRUNC(MAX(training_budget)) TRUNCATED
FROM companies;

--querying structure of the students table
DESC students
--querying data in the students table
SELECT student_id FROM students;
--21 rows returned

--displaying Good morning with username based on first 2 letters of firstname and 5letters of surname
SELECT CONCAT(CONCAT('GOOD MORNING ',SUBSTR(student_firstname,1,2)),SUBSTR(student_surname,1,5)) message
FROM students;