Question: Why the query does not execute and rewrite so that it can be executed SQL postgres CREATE TABLE users ( id int, name varchar(1000), join_date

Why the query does not execute and rewrite so that it can be executed SQL postgres CREATE TABLE users ( id int, name varchar(1000), join_date date, PRIMARY KEY (id) ); CREATE TABLE softwares ( name varchar(200), version varchar(100), released_date date, PRIMARY KEY (name) ); CREATE TABLE licenses ( user_id int REFERENCES users (id), software_name varchar(200), access_code varchar(100), PRIMARY KEY (user_id, software_name) ); 

[4:52 PM]

INSERT INTO users (id, name, join_date) VALUES (48, 'andrew', '2018-01-01'), (49, 'hayden', '2019-01-02'), (50, 'august', '2020-01-02'), (51, 'ayana', '2020-01-01'); 

[4:53 PM]

INSERT INTO softwares (name, version, released_date) VALUES ('MS Word', '2012', '2011-01-20'), ('Chrome', 'v84', '2018-01-01'), ('Sketch', '49', '2016-06-15'); 

[4:53 PM]

 INSERT INTO licenses (user_id, software_name, access_code) VALUES (48, 'MS Word', 'abc123'), (49, 'MS Word', 'def456'), (50, 'MS Word', 'hij789'), (48, 'Sketch', 'x1y2z3'), (51, 'Sketch', 'x2y3z4'); 

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!