Homework

Part 1

Read and answer Lessons 1 and 2 on SQL Bolt.

Part 2

On your local computer:

1. Create a new database car_yards.

2. Create a table of cars with the columns: id, brand, number_of_seats, max_speed using appropriate data types.

3. Insert 5 cars into the table using INSERT INTO.

4. Update the first car's brand to 'ferrari' (remember strings/text are single quotes in PostgreSQL).

5. Delete the 3rd record from the table.

6. Select all cars that have a max_speed greater than 130.