Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Exam
Create table shop(shopid varchar(10),salary int,primary key (sid)); Create table customers(cid varchar(10),cname varchar(10),caddress varchar(10),ccity varchar(15),primary key (cid)); Create table staff(sid varchar(10),sname varchar(10),email varchar(15),shopid varchar(10),salary int,primary key (sid),foreign key(shopid) references shop(shopid)); Create table order(oid varchar(10),odate DATE,shopid varchar(10),cid varchar(10),primary key (oid),foreign key (shopid) references shop(shopid),foreign key (cid) references customers(cid));
run
|
edit
|
history
|
help
0
Audit Example
customers table
SQL HW 1 Appline
Running Total
group_by
Stored procedure
1512081 QUAN LY DE TAI
Digital Innovation One - SQL Server _2
Exam_2_Final
months