Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
sss
--a) create table shipping_service( ship_ID decimal(12), name varchar(32), primary key(ship_ID) ); create table Package( package_ID decimal(12), description varchar(25), date_delivered date, ship_ID decimal(12) references shipping_service(ship_ID), primary key(package_ID)); insert into shipping_service(ship_ID, name) VALUES ('1001', 'Kazpost'), ('1002', 'DHL'), ('1003', 'FedEx'), ('1004', 'PonyExpress'); insert into Package(package_ID, description, date_delivered, ship_ID) VALUES ('9001','IT devices', '25-May-2019', '1001'), ('9002','fragile box', '15-June-2019', '1002'), ('9003','sport equipment', '20-Apr-2018', '1003'), ('9004','express mail', '22-July-2019', null)
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Returning IDs with exactly 3 consecutive months of invoice_amt >2000
asd
Select rows with no intersection on join table and check by date
test 16721723
Sample tables
Food Delivery Website SQL Analysis
Mandelbrot
mandelbrot set
Atividade 2
Demande complète
Please log in to post a comment.