---

rem select * from hr.employees;
rem select last-name from hr.employees;
rem select last_name, first_name, last_name from hr.employees;
rem select last_name as Nazwisko from hr.employees;
rem select last_name as "Nazwisko" from hr.employees;
rem select last_name "Nazwisko pracownika" from hr.employees;
rem select last_name, first_name, last_name  from hr.employees;
rem select last_name, salary "Wynagrodzenie miesieczne",  from hr.employees;
rem "wynagrodzenie roczne" from hr.employees;
rem "select last_name||' '||first_name "Nazwisko i imię" from hr.employees;
rem select last_name, upper(last_name) from hr.employees;

select last_name, salary wynagrodzenie, commission_pct "Procent premia", salary*commission_pct "Kwota premii", salary+from hr.employees;