select employee

select employee_id, first_name ||' '|| last_name "Nama lengkap" ,||"email,(@student.uksw.edu)"||,
Replace(phone_number, '515','+62821') "No HP"
from employees
where employee_id IN(100,102,206);
select employee_id, first_name ||' '|| last_name "Nama lengkap", Replace(phone_number,
'515','+62821') "No HP"
from employees
where employee_id IN(100,102,206);
SELECT
first_name,
last_name,email,
LOWER(SUBSTR(first_name,1,2))
LOWER(SUBSTR(last_name,1,7))
||
LENGTH(LOWER(SUBSTR(first_name,1,2))
LOWER(SUBSTR(last_name,1,7))) AS "User Name"
||
||
FROM employees
where employee_id in(100,102,206);
SELECT
first_name,
last_name,email,
LOWER(SUBSTR(first_name,1,2))
||
LOWER(SUBSTR(last_name,1,7))
||
REPLACE('_','
')
||
LENGTH(LOWER(SUBSTR(first_name,1,2)) || LOWER(SUBSTR(last_name,1,7))) || ' ' ||
@student.uksw.edu || "email"
FROM employees
where employee_id in(100,102,206);
SELECT
first_name,
last_name,email,
LOWER(SUBSTR(first_name,1,2))
||
LOWER(SUBSTR(last_name,1,7))
||
REPLACE('_','
')
||
LENGTH(LOWER(SUBSTR(first_name,1,2)) || LOWER(SUBSTR(last_name,1,7))) "email",
Replace(phone_number, '515','+62821') "No HP"
FROM employees
where employee_id in(100,102,206);
SELECT employee_id, first_name||' '||last_name AS " NAMA LENGKAP",LOWER( SUBSTR
(first_name, 1, 2))||''|| LOWER (REPLACE (last_name,' ','_')) ||''||'@student.uksw.edu' as
EMAIL, REPLACE (phone_number,'515','+6282')AS "PHONE_NUMBER"
FROM employees
WHERE employee_id IN ('100','102','206');