TUGAS

Silahkan kalian kerjakan query Database Pemesanan dibawah ini menggunakan Aplikasi SQL Server, kirim ulang query kedalam LMS ini, terimakasih

CREATE DATABASE Pemesanan

ON (name=Pemesanan, filename="D:\MATERI NGAJAR\BASIS DATA LANJUT\LATIHAN\Pemesanan.mdf", Size=10, maxsize=100, filegrowth=2)

LOG ON (name=Pemesanan_log, filename="D:\MATERI NGAJAR\BASIS DATA LANJUT\LATIHAN\Pemesanan.ldf", Size=4, maxsize=100, filegrowth=2)

Use Pemesanan 

CREATE TABLE Customer

(

ID int primary key not null,

nama varchar (50) not null,

Alamat varchar (50) not null

)

insert into Customer values ('1', 'Arman', 'Bandar Lampung')

insert into Customer values ('2', 'Arisandi', 'Sukabumi')

insert into Customer values ('3', 'Sutarmin', 'Labuhan Ratu')

insert into Customer values ('4', 'Tarigan', 'Way Halim')

select * from Customer

select Customer.ID, Customer.Alamat

from Customer

where Customer.Alamat like 'S%'

select * from Customer

where Alamat IN ('Sukabumi', 'Way Halim') 

CREATE TABLE Order1

(

No_Order int primary key not null,

ID Int not null,

OrderDate Datetime not null

)

insert into order1 values ('101', '1', '02/01/2018')

insert into order1 values ('102', '2', '02/07/2018')

insert into order1 values ('103', '3', '02/05/2018')

insert into order1 values ('101', '4', '02/01/2018')

select * from Order1

select * from Order1

where No_Order between 101 and 103

select * from Order1

where No_Order not between 101 and 102