tempansers.sql

1. \dt
2. \du
3. SELECT * FROM owners;
4. SELECT name FROM owners;
5. SELECT age FROM owners ORDER BY age ASC;
6. SELECT * FROM owners WHERE name = 'Donald';
7. SELECT * FROM owners WHERE age > 30;
8. SELECT * FROM owners WHERE name LIKE 'E%';
9. INSERT INTO owners (name, age) VALUES ('John',33);
10. INSERT INTO owners (name, age) VALUES ('Jane',43);
11. UPDATE owners SET age = 30 where name ='Jane';
12. UPDATE owners SET name ='Janet' WHERE name ='Jane';
13. INSERT INTO properties (name,units, owner_id) VALUES ('Archstone',20,1);
14. DELETE FROM owners WHERE name='Janet';
15. SELECT * FROM properties WHERE name <> 'Archstone' AND property_id NOT IN (3,5) ORDER BY name ASC;
16. SELECT COUNT (*) FROM properties;
17. SELECT MAX(age) FROM owners;
18. SELECT * FROM owners LIMIT 3;

Bonus (this might require you to look up documentation online)
19. ALTER TABLE properties ADD CONSTRAINT owner_fk FOREIGN KEY (owner_id) REFERENCES owners (owner_id) ON DELETE CASCADE;
20. SELECT owners.name, properties.name FROM owners JOIN properties ON owners.owner_id = properties.owner_id;
1. ALTER TABLE properties RENAME COLUMN "name" TO "property_name";
2. SELECT COUNT(*) FROM properties WHERE owner_id BETWEEN 1 AND 3;

1. \dt
2. \du
3. SELECT * FROM owners;
4. SELECT name FROM owners;
5. SELECT age FROM owners ORDER BY age ASC;
6. SELECT name FROM owners WHERE name = 'Mary';
7. SELECT age FROM owners WHERE age > 30;
8. SELECT name FROM owners WHERE name LIKE 'E%';
9. INSERT INTO owners (name, age) VALUES ('John', 33);
10. INSERT INTO owners (name, age) VALUES ('Jane', 43);
11. UPDATE owners SET age = 30 WHERE name = 'Jane';
12. UPDATE owners SET name = 'Janet' WHERE name = 'Jane';
13. INSERT INTO properties (name, number_of_units, owner_id) VALUES ('Archstone', 20, 1);
14. DELET FROM owners WHERE name = 'Janet';
15. SELECT * FROM properties WHERE name <> 'Archstone' AND property_id NOT IN (3, 5);
16. SELECT count(*) FROM properties;
17. SELECT age FROM owners ORDER BY age DESC LIMIT 1;
18. SELECT name FROM owners ORDER BY owner_id LIMIT 3;

BONUS
1. ALTER TABLE owners ADD COLUMN fk INT
     REFERENCES owners(owner_id)
     ON DELETE CASCADE
   ;
2. SELECT * FROM owners AS o
    INNER JOIN properties AS p
      ON p.owner_id = o.owner_id
   ;
3. ALTER TABLE properties
     RENAME COLUMN name TO property_name;
4. SELECT count(*) FROM properties WHERE owner_id >= 1 AND owner_id <= 3;
5. DROP TABLE owners CASCADE;
  Also deletes rows with foreign key references in the properties tables because we set up ON CASCADE DELETE.