tugas BASISDATA3

1. membuat database penjualan2;

2. lihat databases;

3. gunakan database penjualan2

4. isi tabel pelanggan dengan perintah insert

5. select * from pelanggan;

6. select *  from pelanggan order by kode asc;

7. select * from pelanggan order by nama desc;

8. select * from pelanggan group by tipe;

9. select * from pelanggan where nama like '%dewa%';

10. select * from pelanggan where nama like '%tria%' order by alamat asc;

11. select * from pelanggan where nama like 'putra%' order by alamat;

12. select * from pelanggan where alamat like '%12%' order by tipe desc;

13. select * from pelanggan where nama like '%na%' order by nama asc;

14. select * from pelanggan where nama like '%putra%' order by alamat;