Notes

--describing companies table
DESC companies;

--query to show the training_budget of all companies
SELECT company_name, training_budget FROM companies;
--the datatype of training_budget allows 2 decimal places but no decimal places are shown in result

--given update statement
UPDATE companies
SET training_budget = training_budget+(training_budget*0.17867865);
--the update statement updates the training budget of all companies

--requerying to show the updated training_budget of all companies
SELECT company_name, training_budget FROM companies;
--the decimal places are shown

--query to show the CEIL, FLOOR, ROUND, TRUNC values of training_budget
SELECT training_budget"Original",
CEIL(training_budget)"CEIL",
FLOOR(training_budget)"FLOOR",
ROUND(training_budget,2)"ROUND",
TRUNC(training_budget)"TRUNC"
FROM companies;

--query to show max value
SELECT CEIL(MAX(training_budget))"CEIL",
FLOOR(MAX(training_budget))"FLOOR",
ROUND(MAX(training_budget),2)"ROUND",
TRUNC(MAX(training_budget))"TRUNC"
FROM companies;