RSS
 

LATIHAN

17 Mar

1.Tampilkan NO-ORDER, JUMLAH ORDER dari tabel ORDER untuk JUMLAH ORDER > 100

2.Tampilkan selisih antara nilai tertinggi dan nilai terendah untuk masing-masing matakuliah dari tabel transkrip.
3.Tampilkan nama karyawan yang berada pada  departemen yang sama dengan Ida
4.Tampilkan nama mahasiswa peserta matakuliah 434 yang memiliki nilai lebih besar dari rata-rata nilai matakuliah tersebut.
 
32 Comments

Posted in TUGAS

 

Leave a Reply

 

 
 
 

  1. Hari Novian Primanto

    March 20, 2012 at 4:31 am

    1. select no_order, count(*) jumlah_order
    from order
    group by no_order
    having count (*) > 100;

    2. select mk, max (nilai) – min (nilai)
    from transkip
    group by mk;

    3. select nama, department_id
    from employees
    where department_id = (select department_id from employees where nama = ‘ida’);

    4. select nama
    from mk
    where id_mk = ‘434’ and nilai > avg((0.3*uts)+(0.3*uas)+(0.4*tugas));

    Reply
     

  2. Christian Bagus wiratma (10390100016)

    March 20, 2012 at 4:33 am

    select no-order,jumlah-order
    from order
    where jumlah-order>100;

    select matakuliah, max(nilai)-min(nilai)
    from transkrip;

    select nama_karyawan
    from employee
    where id-department= (select id-department
    from employee
    where nama_karyawan=”ida”);

    select nama-mahasiswa
    from nilai
    where no-peserta=434 And nilai>(select avg(nilai)
    from nilai
    group by matakuliah);

    Reply
     

  3. Andrik arifin

    March 20, 2012 at 4:47 am

    10.3901.00015
    Andrik Arifin

    1. select no_order, count(*) jumlah_order
    from order
    group by no_order
    having count (*) > 100;

    2. select mk, max ((nilai) – min (nilai))
    from transkip
    group by mk;

    3. select nama, department_id
    from employees
    where department_id = (select department_id from employees where nama = ‘ida’);

    4. select nama
    from mk
    where kode_mk = ‘434’ and nilai > avg((0.3*uts)+(0.3*uas)+(0.4*tugas));

    Reply
     

  4. M. As'adi Sofyan

    March 20, 2012 at 4:51 am

    10.3901.00017
    M. As’adi Sofyan

    1. select no_order, count(*) jumlah_order
    from order
    group by no_order
    having count (*) > 100;

    2. select mk, max ((nilai) – min (nilai))
    from transkip
    group by mk;

    3. select nama, department_id
    from employees
    where department_id = (select department_id from employees where nama = ‘ida’);

    4. select nama
    from mk
    where kode_mk = ‘434’ and nilai > avg((0.3*uts)+ (0.3*uas)+(0.4*tugas));

    Reply
     

  5. [LATIHAN] Pemrograman Basis Data 1 (Sabtu, 17 Maret 2012) | Rizal Lare Osing

    March 20, 2012 at 5:10 am

    […] Kuliah : Pemrograman Basis Data 1 NIM : 10.39010.0057 Nama : Rizal Miftahus Salmi Link Latihan : http://blog.stikom.edu/nunuk/2012/03/17/latihan/ […]

    Reply
     

  6. Rizal Lare Osing

    March 20, 2012 at 5:11 am

    Ini jawaban dari latihan bu..
    http://www.rizallaros.com/latihan-pemrograman-basis-data-1-sabtu-17-maret-2012-209/
    arigatou.. ^_^

    Reply
     

  7. novan andrianto

    March 20, 2012 at 5:13 am

    Bu ini jawaban latihannya…

    1.
    Select no_order, jumlah_order
    from order
    where jumlah_order > 100;

    2.
    select mk, max(nilai) – min(nilai)
    from transkrip
    group by mk;

    3.
    select nama
    from karyawan
    where departemen_id = (select nama
    from karyawan
    where nama = “ida”);

    4.
    select nama
    from nilai
    where mk = 434 and nilai > (select avg(nilai)
    from nilai
    group by mk);

    by
    Novan Andrianto (10390100048)

    Reply
     

  8. Arman Budi Mahendra (09390100046)

    March 20, 2012 at 5:32 am

    1.select no_order,jumlah_order
    from order
    where jumlah_order>100;

    2.select matakuliah, max(nilai)-min(nilai)
    from transkrip;

    3.select nama_karyawan
    from employees
    where id-department= (select id_department from employees where nama_karyawan=’ida’);

    4.select nm_mahasiswa
    from nilai
    where no-peserta=434 And nilai>(select avg(nilai)
    group by matakuliah);

    Reply
     

  9. Rahardiyan Arya Yudha (10390100025)

    March 20, 2012 at 5:35 am

    1.
    Select no_order, Jumlah_order
    From Order
    Where Jumlah_order > 100 ;

    2.
    Select MAX(nilai) – MIN(nilai)
    From Transkrip

    3.
    Select Nama_karyawan
    From Department
    Where Department_ID =
    (Select Department_ID
    From Department
    Where Nama_Karyawan = “Ida”) ;

    4.
    Select Nama_Mahasiswa
    From Nilai
    Where No_Mahasiswa = ‘434’ and Nilai >
    (Select AVG(Nilai)
    From Nilai
    Group By Nama_Mahasiswa);

    Reply
     

  10. Deny Sefrianto (09390100023)

    March 20, 2012 at 5:52 am

    1.select no_order,jumlah_order
    from order
    where jumlah_order>100;

    2.select matakuliah, max(nilai)-min(nilai)
    from transkrip;

    3.select nama_karyawan
    from employees
    where department_id= (select department_id from employees where nama_karyawan=’ida’);

    4.select nm_mahasiswa
    from nilai
    where no_peserta=’434′ And nilai>avg((0.3*uts)+ (0.3*uas)+(0.4*tugas));

    Reply
     

  11. moch picter santoso

    March 20, 2012 at 6:42 am

    1. select no_order, count(*) jumlah_order
    from order
    group by no_order
    having count (*) > 100;

    2. select mk, max ((nilai) – min (nilai))
    from transkip
    group by mk;

    3. select nama, department_id
    from employees
    where department_id = (select department_id from employees where nama = ‘ida’);

    4. select nama
    from mk
    where kode_mk = ’434′
    having nilai > avg((0.3*uts)+(0.3*uas)+(0.4*tugas))
    group by nama;

    Reply
     

  12. Abd. rosyid

    March 20, 2012 at 6:54 am

    nim :10390100001
    nama : abd.Rosyid

    1.
    select no_order,sum(order)
    from order
    group by no_order
    having sum(order)>100;

    2.
    select matakuliah max(nilai)-min(nilai)
    from transkrip;

    3.
    select nama_karyawan
    from employees
    where department=’ida’;

    4.
    select nama_mahasiswa
    from nilai
    where peserta=434 And nilai>(avg(nilai)
    group by matakuliah)
    having avg(nilai);

    Reply
     

  13. Abd. rosyid

    March 20, 2012 at 6:54 am

    nim :10390100001
    nama : abd.Rosyid

    1.
    select no_order,sum(order)
    from order
    group by no_order
    having sum(order)>100;

    2.
    select matakuliah max(nilai)-min(nilai)
    from transkrip;

    3.
    select nama_karyawan
    from employees
    where department=’ida’;

    4.
    select nama_mahasiswa
    from nilai
    where peserta=434 And nilai>(avg(nilai)
    group by matakuliah
    having avg(nilai);

    Reply
     

  14. Octriana Muliawati (10390100021)

    March 20, 2012 at 6:59 am

    http://octrianamuliawati.blogspot.com/2012/03/latihan-pbd.html

    Reply
     

  15. Yusuf Bachtiar ( 10.39010.0034 )

    March 20, 2012 at 7:02 am

    link blog : http://yid57maju.blogspot.com/2012/03/latihan-pbd1.html

    Reply
     

  16. tirta swastika

    March 20, 2012 at 7:19 am

    1. select NO_ORDER, count(*) JUMLAH_ORDER
    from order
    group by no_order
    having count (*) > 100;

    2. select mk, max (nilai) – min (nilai)
    from transkip
    group by mk;

    3. select nama, department_id
    from employees
    where department_id = (select department_id from employees where nama = ‘ida’);

    4. select nama
    from mk
    where id_mk = ’434′ and nilai > avg((0.3*uts)+(0.3*uas)+(0.4*tugas));

    Reply
     

  17. Anas Bakhtiar

    March 20, 2012 at 7:26 am

    1.
    select no_order,sum(order)
    from order
    group by no_order
    having sum(order)>100;

    2.
    select matakuliah max(nilai), min(nilai)
    from transkrip;

    3.
    select nama_karyawan
    from employees
    where department=’ida’;

    4.
    select nama_mahasiswa, avg(nilai) “Rata_Nilai”
    from khs
    where peserta=434
    group by matakuliah
    having nilai>avg(nilai);

    Reply
     

    • Cahyo Nugroho

      March 20, 2012 at 7:41 am

      1.
      select no_order,sum(order)
      from order
      group by no_order
      having sum(order)>100;

      2.
      select matakuliah max(nilai), min(nilai)
      from transkrip
      group by nama_mk;

      3.
      select nama_karyawan
      from employees
      where department_id=(select department_id from employees where nama=’ida’);

      4.
      select nama_mahasiswa, avg(nilai)
      from khs
      where matakuliah=434
      group by nama_mahasiswa
      having nilai> avg(nilai);

      Reply
       

      • LinLin Antebellum

        March 20, 2012 at 8:15 am

        LINDA TRISIA HARDIANTI
        (10.39010.0058)

        1.
        Select NO-ORDER, Count(*) ”JUMLAH_ORDER”
        From ORDER
        Group by NO-ORDER
        Having Count (*) “JUMLAH_ORDER” > 100;

        2.
        Select (Max (nilai)-Min(nilai)) ”SELISIH”
        From TRANSKRIP
        Group by NAMA_KULIAH

        3.
        Select NAMA
        From EMPLOYEES
        Where DEPARTMENT_ID
        (Select DEPARTMENT_ID
        From EMPLOYEES
        Where NAMA = ‘ida’);

        4.
        Select NAMA,
        from MAHASISWA
        where KODE_MK = ’434′ and nilai > avg((0.3*uts)+(0.3*uas)+(0.4*tugas));

        Reply
         

  18. agung permadi

    March 20, 2012 at 7:29 am

    1. select NO-ORDER, JUMLAH_ORDER from order
    where JUMLAH_ORDER > 100;

    2. select matakuliah, max(matakuliah) – min(matakuliah) “rata-rata nilai” from transkrip;

    3. select nama_karyawan, departemen from employees
    where id_departmen = (select id_department from employees where nama_karyawan=’ida’;

    4. select nama_mahasiswa, avg((0.3*uts)+(0.3*uas)+(o.4*tugas)) from mahasiswa
    where peserta_matakuliah = ‘434’
    having nilai> avg((0.3*uts)+(0.3*uas)+(o.4*tugas))
    group by nama_mahasiswa;

    Reply
     

  19. Angga Sabastian 10390100002

    March 20, 2012 at 7:39 am

    1. select no_order, jumlah order
    from order
    where order > 100

    2. select mk, max ((nilai) – min (nilai))
    from transkip
    group by mk;

    3. select nama, department_id
    from employees
    where department_id = (select department_id from employees where nama = ‘ida’);

    4. select nama
    from mk
    where kode_mk = ’434′ and nilai > avg((0.3*uts)+(0.3*uas)+(0.4*tugas));

    Reply
     

  20. Ignatius Dimas S.S (08390100037)

    March 20, 2012 at 7:49 am

    1. SELECT NO-ORDER,JUMLAH_ORDER
    FROM ORDER
    WHERE JUMLAH_ORDER>100;

    2. SELECT KODE_MK,MAX(NILAI)-MIN(NILAI)
    FROM transkrip
    GROUP BY KODE_MK;

    3. SELECT NAMA_KARYAWAN
    FROM KARYAWAN
    WHERE DEPARTEMEN_ID=(SELECT DEPARTEMEN_ID
    FROM KARYAWAN
    WHERE NAMA_KARYAWAN=’Ida’);

    4. SELECT NAMA_MAHASISWA
    FROM MASTER_MHS
    WHERE KODE_MK=434 AND NILAI>(SELECT AVG(NILAI)
    FROM HISTORI_MHS);

    Reply
     

    • Teguh Budiyantono (07390100016)

      March 20, 2012 at 7:52 am

      1. SELECT NO-ORDER,JUMLAH_ORDER
      FROM ORDER
      WHERE JUMLAH_ORDER>100;

      2. SELECT KODE_MK,MAX(NILAI)-MIN(NILAI) AS SELISIH
      FROM transkrip
      GROUP BY KODE_MK;

      3. SELECT NAMA_KARYAWAN
      FROM KARYAWAN
      WHERE DEPARTEMEN_ID IN(SELECT DEPARTEMEN_ID
      FROM KARYAWAN
      WHERE NAMA_KARYAWAN=’Ida’);

      4. SELECT NAMA_MAHASISWA
      FROM MASTER_MHS
      WHERE KODE_MK=434 AND NILAI>(SELECT AVG(NILAI)
      FROM HISTORI_MHS);

      Reply
       

  21. (10390100054) Adam Bagus P.

    March 20, 2012 at 8:07 am

    1.select no_order,jumlah_order
    from order
    where jumlah_order>100;

    2.select matakuliah, max(nilai)-min(nilai)
    from transkrip;

    3.select nama_karyawan
    from employees
    where department_id= (select department_id from employees where nama_karyawan=’ida’);

    4.select nm_mahasiswa
    from nilai
    where no_peserta=’434′ And nilai>avg((0.3*uts)+ (0.3*uas)+(0.4*tugas));

    Reply
     

  22. Resa Dwiantoro

    March 20, 2012 at 8:14 am

    http://echadwiantoro.wordpress.com/2012/03/20/tugas2-pbd/

    Resa Dwiantoro
    10.39010.0049

    Reply
     

  23. Dimas Achmad Kinanto

    March 20, 2012 at 8:19 am

    10.39010.0044
    Dimas Achmad Kinanto

    1.
    select no_order, jumlah_order
    from order
    where jumlah_order > 100

    2.
    select mata_kuliah, max(nilai)-min(nilai)
    from transkrip
    group by mata_kuliah;

    3.
    select nama_karyawan, department_id
    from employees
    where department_id = department_id from employees where nama_karyawan = ‘Ida’;

    4.
    select nama_mhs
    from mk
    where kode_mk = ‘434’ and > AVG ((0.3*uts)+(0.3*uas)+(0.4*tugas))
    group by nama_mhs;

    Reply
     

  24. M.Alfan.R (07390100041)

    March 20, 2012 at 8:21 am

    1. SELECT NO-ORDER,JUMLAH_ORDER
    FROM ORDER
    WHERE JUMLAH_ORDER>100;

    2. SELECT KODE_MK,MAX(NILAI)-MIN(NILAI)
    FROM transkrip
    GROUP BY KODE_MK;

    3. SELECT NAMA_KARYAWAN
    FROM KARYAWAN
    WHERE DEPARTEMEN_ID=(SELECT DEPARTEMEN_ID
    FROM KARYAWAN
    WHERE NAMA_KARYAWAN=’Ida’);

    4. SELECT NAMA_MAHASISWA
    FROM MASTER_MHS
    WHERE KODE_MK=434 AND NILAI>(SELECT AVG(NILAI)
    FROM HISTORI_MHS);

    Reply
     

  25. zeni wahyu

    March 20, 2012 at 8:22 am

    1.
    Select no_order, Count (*) jumlah_order
    From order
    Group by no_order
    Having Count (*) > 100;

    2.
    Select Max (nilai)-Min(nilai)
    From transkrip
    Group by kode_mk

    3.
    Select nama
    From employees
    Wheredepartment_id
    (Select department_id
    From employees
    Where nama = ‘ida’);

    4.
    select nama
    from nilai
    where kode_mk =434
    and nilai (select avg(nilai) from nilai where nilai > avg(nilai) group by avg(nilai))

    Reply
     

  26. Isna CZ

    March 20, 2012 at 8:45 am

    isna chusnia zunaidi
    10390100036

    link nya ini buuukkk…
    taniania55.wordpress.com/2012/03/20/pbd1-2/

    Reply
     

  27. Sabrina(08390100011)

    March 20, 2012 at 8:49 am

    1. SELECT NO-ORDER,JUMLAH_ORDER
    FROM ORDER
    WHERE JUMLAH_ORDER>100;

    2. SELECT KODE_MK,MAX(NILAI)-MIN(NILAI)
    FROM transkrip
    GROUP BY KODE_MK;

    3. SELECT NAMA_KARYAWAN
    FROM KARYAWAN
    WHERE DEPARTEMEN_ID=(SELECT DEPARTEMEN_ID
    FROM KARYAWAN
    WHERE NAMA_KARYAWAN=’Ida’);

    4. SELECT NAMA_MAHASISWA
    FROM MASTER_MHS
    WHERE KODE_MK=434 AND NILAI>(SELECT AVG(NILAI)
    FROM HISTORI_MHS);

    Reply
     

  28. Sabrina(08390100011)

    March 20, 2012 at 8:52 am

    1. SELECT NO-ORDER,JUMLAH_ORDER
    FROM ORDER
    WHERE JUMLAH_ORDER>100;

    2. SELECT KODE_MK,MAX(NILAI)-MIN(NILAI) AS SELISIH
    FROM transkrip
    GROUP BY KODE_MK;

    3. SELECT NAMA_KARYAWAN
    FROM KARYAWAN
    WHERE DEPARTEMEN_ID IN(SELECT DEPARTEMEN_ID
    FROM KARYAWAN
    WHERE NAMA_KARYAWAN=’Ida’);

    4. SELECT NAMA_MAHASISWA
    FROM MASTER_MHS
    WHERE KODE_MK=434 AND NILAI>(SELECT AVG(NILAI)
    FROM HISTORI_MHS);

    Reply
     

  29. Rio S Wibowo (10390100024)

    March 20, 2012 at 9:42 am

    select no_order, count(*) jumlah_order
    from order
    group by no_order
    having count (*) > 100;

    select mk, max ((nilai) – min (nilai))
    from transkip
    group by mk;

    select nama, department_id
    from employees
    where department_id = (select department_id from employees where nama = ‘ida’);

    select nama
    from mk
    where kode_mk = ’434′ and nilai > avg((0.3*uts)+(0.3*uas)+(0.4*tugas));

    Reply
     
 
Skip to toolbar