(A) TakeHome SBD liesty

Buat temen-temen kelas praktek SBD C asdos :Lizty..
Ni saya kasih sedikit bantuan..
Bukan bantuan deng.! emang ini jawabannya.. Hahaha..
Semoga berguna.. HAhaha


Nomor satu:

select first_name + last_name as "nama panjang",
upper(substring(first_name+last_name,1,employee_id)) as "Nama Besar",
lower(substring(first_name+last_name,employee_id+1,len(first_name+last_name))) as "Nama Kecil"
from employees
where not (employee_id=9)and not (employee_id=10)
order by employee_id desc;




Nomor dua:
select first_name + last_name as "Full Name",
len(first_name+last_name) as "Length",
lower(substring((first_name+last_name),1,(len(first_name+last_name)/2-1))) +' ' +
upper(substring((first_name+last_name),(len(first_name+last_name)/2),2)) + ' '+
lower(substring((first_name+last_name),(len(first_name+last_name)/2+2),len(first_name+last_name)))
as "change case"
from employees
where ((len(first_name+last_name)%2=0))
order by len(first_name+last_name);