Uploaded by User48701

Tes1 SBD1 O 672018299

advertisement
1
select 'kebab,burger,sate,bakso' "Nama Makanan",LPAD('mancing mania', 17, '-')||RPAD(' ',5, '')"Komentar Netizen", (319/29) + 15"Letak Huruf 'o'",'kebab,sate,burger' "makanan favorit"
from dual;
2.
SELECT first_name||' '||last_name ||' memiliki nilai rekayasa '|| CASE DEPARTMENT_ID-10 WHEN 100
THEN 'A'
WHEN 80 THEN 'B'
WHEN 70 THEN 'C'
ELSE 'E' END "Nilai Pegawai"
FROM employees
order by department_id desc;
3
SELECT first_name||' '||last_name ||' sudah bekerja selama '|| ROUND(MONTHS_BETWEEN(SYSDATE,
hire_date))||' bulan '||'gaji yang sudah diterima sebesar' ||' Rp. '||
salary*ROUND(MONTHS_BETWEEN(SYSDATE, hire_date)) "GAJI SAMPAI SAAT INI "
FROM employees;
Download