stud_emp.sql 384 B

123456789101112131415
  1. CREATE TABLE stud_emp (
  2. name text,
  3. age int4,
  4. --location point,
  5. salary int4,
  6. manager name,
  7. gpa float8,
  8. percent int4
  9. );
  10. INSERT INTO stud_emp VALUES
  11. ('jeff', 23, /*(8,7.7),*/ 600, 'sharon', 3.50000000000000000e+00, null),
  12. ('cim', 30, /*(10.5,4.7),*/ 400, null, 3.39999999999999990e+00, null),
  13. ('linda', 19, /*(0.9,6.1),*/ 100, null, 2.89999999999999990e+00, null);