Legitimate Resale, MySQL

Legitimate Resale

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

drop table Legitimate_Resale;

create table Legitimate_Resale (id integer primary key, product text, quantity integer, hazclass text, price integer);

insert into Legitimate_Resale values(1, "irradiator", 6, "restricted", 7000);
insert into Legitimate_Resale values(2, "irradiator gamma", 1, "banned", 299999);
insert into Legitimate_Resale values(3, "gas mask", 20, "neutral", 1500);
insert into Legitimate_Resale values(4, "blank tapes", 50, "neutral", 200);
insert into Legitimate_Resale values(5, "knockoff sunglasses", 35, "neutral", 1400);
insert into Legitimate_Resale values(6, "flash capsules", 8, "restricted", 3499);
insert into Legitimate_Resale values(7, "Mister Tinkles the Robot Kitten", 2, "banned", 6910499);
insert into Legitimate_Resale values(8, "generator", 12, "neutral", 4999);
insert into Legitimate_Resale values(9, "voice modulator", 1, "restricted", 12000);
insert into Legitimate_Resale values(10, "Atomic Fission: A Junior Pocket Guide", 3, "banned", 800);
insert into Legitimate_Resale values(11, "'ironi-nonium' pills", 426, "restricted", 100);
insert into Legitimate_Resale values(12, "fingerprinting kit", 10, "restricted", 2500);
insert into Legitimate_Resale values(13, "ironium ant", 1, "neutral", 80000);
insert into Legitimate_Resale values(14, "mini generator", 24, "neutral", 2499);
insert into Legitimate_Resale values(15, "medium glass tank", 1, "neutral", 2849);

select product, hazclass, quantity, price

from Legitimate_Resale

order by hazclass, product;


run \| edit \| history \| help	0