Question: Create a table called 'trip' to store information about different trips. It should have the following columns; id int from_country int (will reference country id
Create a table called 'trip' to store information about different trips. It should have the following columns;
- id int
- from_country int (will reference country id from country table)
- to_country int
- trip_date date
- purpose char(50)
Next, populate this table with 4-5 records. the date value you will be inserting should be formatted like this: '2018-01-01'.
Last, select records from this table.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
