Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started