A sql-5-3.sql file has been opened for you.
In the sql-5-3.sql file:
1) Use the college database
2) Write a SQL SELECT statement that joins the data from thecollege.classrooms table and the college.courses tabletogether.
these are the constraints on the two tables in question, I haveno idea where I’m going wrong.
1. Create a courses table with this definition (try using a multi-line SQL statement): +——— —— ——- ——+—–+—————– | Field | Type | Null | Key | Default | Extra +——— ———- ——————————————— | id | int(3) unsigned | NO | PRI | NULL | auto_increment | title | varchar(255) NO | UNI | NULL || | credits | tinyint(2) unsigned | NO | 1 | +———+—– —— ——+—–+———+—– 1. Create a classrooms table with this definition (try using a multi- line SQL statement): +———– —————–+——+—–+———+—————-+ | Field | Type | Null | Key | Default | Extra +—————— —————————————————+ | id | int(3) unsigned | NO | PRI | NULL | auto_increment | | room_num | int(4) unsigned | NO | UNI | NULL | | course_id | int(3) unsigned | YES | MUL | NULL | +- – – – – —— —– ————-+—–+———+— = + Show transcribed image text 1. Create a courses table with this definition (try using a multi-line SQL statement): +——— —— ——- ——+—–+—————– | Field | Type | Null | Key | Default | Extra +——— ———- ——————————————— | id | int(3) unsigned | NO | PRI | NULL | auto_increment | title | varchar(255) NO | UNI | NULL || | credits | tinyint(2) unsigned | NO | 1 | +———+—– —— ——+—–+———+—–
1. Create a classrooms table with this definition (try using a multi- line SQL statement): +———– —————–+——+—–+———+—————-+ | Field | Type | Null | Key | Default | Extra +—————— —————————————————+ | id | int(3) unsigned | NO | PRI | NULL | auto_increment | | room_num | int(4) unsigned | NO | UNI | NULL | | course_id | int(3) unsigned | YES | MUL | NULL | +- – – – – —— —– ————-+—–+———+— = +
Expert Answer
Answer to A sql-5-3.sql file has been opened for you. In the sql-5-3.sql file: 1) Use the college database 2) Write a SQL SELECT s…