Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- insert into customer values
- ('bob', 'smith', '12 a road', 'bob@email.com', 'xbox', '1988-08-10'),
- ('paul', 'jones', '13 a road', 'paul@email.com', 'pc', '1988-08-11'),
- ('leo', 'overhill', '14 a road', 'leo@email.com', 'playstation', '1988-08-12'),
- ('ben', 'potter', '15 a road', 'ben@email.com', 'nintendo 64', '1988-08-13'),
- ('billy', 'agran', '16 a road', 'billy@email.com', 'pc', '1988-08-14');
- insert into games values
- ('overwatch', 'pc', '13', '30'),
- ('fifa', 'xbox', '8', '30'),
- ('spyro', 'playstation', '5', '30'),
- ('hearthstone', 'pc', '9', '30'),
- ('worms', 'pc', '16', '30'),
- ('mario kart', 'nintendo 64', '7', '30'),
- ('lemmings', 'playstation', '3', '30'),
- ('forza', 'xbox', '20', '30'),
- ('gta', 'xbox', '18', '30'),
- ('donkey kong', 'nintendo 64', '2', '30');
- insert into sales values
- ('1', '1', '2018/04/15', '30'),
- ('3', '3', '2018/04/15', '30'),
- ('4', '4', '2018/04/15', '30'),
- ('5', '5', '2018/04/15', '30'),
- ('3', '6', '2018/04/15', '30'),
- ('3', '7', '2018/04/15', '30'),
- ('2', '8', '2018/04/15', '30'),
- ('4', '9', '2018/04/15', '30'),
- ('5', '10', '2018/04/15', '30'),
- ('1', '1', '2018/04/15', '30'),
- ('1', '2', '2018/04/15', '30'),
- ('2', '3', '2018/04/15', '30'),
- ('2', '4', '2018/04/15', '30'),
- ('4', '5', '2018/04/15', '30');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement