Advertisement
Guest User

Untitled

a guest
Apr 15th, 2018
320
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.25 KB | None | 0 0
  1. insert into customer values
  2. ('bob', 'smith', '12 a road', 'bob@email.com', 'xbox', '1988-08-10'),
  3. ('paul', 'jones', '13 a road', 'paul@email.com', 'pc', '1988-08-11'),
  4. ('leo', 'overhill', '14 a road', 'leo@email.com', 'playstation', '1988-08-12'),
  5. ('ben', 'potter', '15 a road', 'ben@email.com', 'nintendo 64', '1988-08-13'),
  6. ('billy', 'agran', '16 a road', 'billy@email.com', 'pc', '1988-08-14');
  7.  
  8. insert into games values
  9. ('overwatch', 'pc', '13', '30'),
  10. ('fifa', 'xbox', '8', '30'),
  11. ('spyro', 'playstation', '5', '30'),
  12. ('hearthstone', 'pc', '9', '30'),
  13. ('worms', 'pc', '16', '30'),
  14. ('mario kart', 'nintendo 64', '7', '30'),
  15. ('lemmings', 'playstation', '3', '30'),
  16. ('forza', 'xbox', '20', '30'),
  17. ('gta', 'xbox', '18', '30'),
  18. ('donkey kong', 'nintendo 64', '2', '30');
  19.  
  20. insert into sales values
  21. ('1', '1', '2018/04/15', '30'),
  22. ('3', '3', '2018/04/15', '30'),
  23. ('4', '4', '2018/04/15', '30'),
  24. ('5', '5', '2018/04/15', '30'),
  25. ('3', '6', '2018/04/15', '30'),
  26. ('3', '7', '2018/04/15', '30'),
  27. ('2', '8', '2018/04/15', '30'),
  28. ('4', '9', '2018/04/15', '30'),
  29. ('5', '10', '2018/04/15', '30'),
  30. ('1', '1', '2018/04/15', '30'),
  31. ('1', '2', '2018/04/15', '30'),
  32. ('2', '3', '2018/04/15', '30'),
  33. ('2', '4', '2018/04/15', '30'),
  34. ('4', '5', '2018/04/15', '30');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement