one to many.sql - insert into nation values'UK'United...

This preview shows page 1 out of 1 page.

insert into nation values ('UK','United Kingdom',1); insert into nation values ('USA','United States',0.67); insert into nation values ('AUS','Australia',0.46); insert into nation values ('IND','India',0.0228); insert into stock values ('FC','Freedonia Copper',27.5,10529,1.84,16,'UK'); insert into stock values ('PT','Patagonian Tea',55.25,12635,2.5,10,'UK'); insert into stock values ('AR','Abyssinian Ruby',31.82,22010,1.32,13,'UK'); insert into stock values ('SLG','Sri Lankan Gold',50.37,32868,2.68,16,'UK'); insert into stock values ('ILZ','Indian Lead & Zinc',37.75,6390,3,12,'UK'); insert into stock values ('BE','Burmese Elephant',0.07,154713,0.01,3,'UK'); insert into stock values ('BS','Bolivian Sheep',12.75,231678,1.78,11,'UK'); insert into stock values ('NG','Nigerian Geese',35,12323,1.68,10,'UK'); insert into stock values ('CS','Canadian Sugar',52.78,4716,2.5,15,'UK'); insert into stock values ('ROF','Royal Ostrich Farms',33.75,1234923,3,6,'UK'); insert into stock values ('MG','Minnesota Gold',53.87,816122,1,25,'USA'); insert into stock values ('GP','Georgia Peach',2.35,387333,0.2,5,'USA'); insert into stock values ('NE','Narembeen Emu',12.34,45619,1,8,'AUS'); insert into stock values ('QD','Queensland Diamond',6.73,89251,0.5,7,'AUS'); insert into stock values ('IR','Indooroopilly Ruby',15.92,56147,0.5,20,'AUS'); insert into stock values ('BD','Bombay Duck',25.55,167382,1,12,'IND');
Image of page 1
  • Spring '13
  • PostgreSQL, stock values, nationname, SELECT nationname, nation values

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern