Question

Use an INSERT INTO statement with a subquery containing a SQL string function to create user names for the volunteers based on their legal names and insert them into the table.

+----------------------+
| Tables_in_volunteers |
+----------------------+
| address              |
| email                |
| funds                |
| hours                |
| person               |
| phone                |
| users                |
+----------------------+

users legal names are in the address table

user table is :

CREATE TABLE USERS(volunteer_id INT NOT NULL, username VARCHAR(50), PRIMARY KEY (username), FOREIGN KEY (volunteer_id) REFERENCES PERSON(volunteer_id));

address table is

CREATE TABLE ADDRESS(name VARCHAR(255), volunteer_id INT NOT NULL, address VARCHAR(255), sex TEXT, age INT, date_joined DATE, PRIMARY KEY (name,date_joined), FOREIGN KEY (volunteer_id) REFERENCES PERSON(volunteer_id));

Answer 1

The query is given as:

INSERT INTO USERS (volunteer_id, username)

SELECT volunteer_id, name from ADDRESS;