MYSQL [jsohn6]> DESC COURSE; Field | Туре | Null | Key | Default | Extra | | PRI | NULL MUL | NULL COURSE_TYPE DEPARTMENT_ID COURSE_TITLE COURSE_DESCRIPTION | varchar(30) | YES | COURSE_TYPE_CODE varchar(20) int(11) varchar(20) NO | YES YES NULL | NULL | MUL | NULL | varchar(10) | YES 5 rows in set (0.06 sec) MYSQL [jsohn6]> INSERT INTO COURSE VALUES('Undergraduate','101,'Fashion','Art of fashion design','F'); '> ; '> <' -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo he right syntax to use near 'Fashion','Art of fashion design','F');

Instructorld 1 • Courseld CourseCode 9630 MATH109 Course CourseName Linear Algebra Capacity 175 4964 PHILAT Intro to Philosophy 50 4253 MATH19 Number Theory 150 1896 HIST66 American History 25 8048 HIST58 World History 125 2133 Instructor Instructorld InstructorName Rank Department Del Day Associate Professor Math Rob Ruiz Associate Professor Philosophy Aya Diaz Associate Professor History Note: Both tables may not be necessary to complete this level. Select the rows returned by the query below. SELECT CourseName, Capacity, InstructorId FROM Course C WHERE Capacity > (SELECT AVG (Capacity) FROM Course WHERE InstructorId = c.InstructorId); CourseName Linear Algebra Capacity Instructorld 175 1 Intro to Philosophy 50 2 150 Number Theory American History 25 World History 125 2133

Guided Table Build: We will be Creating a Table called Student For the 6 following questions, your submission will be the query that shows you’ve created the table conforming to the requirements. Create a Table Named Student. The first column should be named ID, and have a data type of Integer The second column should be named First_Name, and have a data type of varchar(255). The third column should be named Last_Name, and have a data type of varchar(255) The fourth column should be named DOB (short for date of birth), and have a data type of date. The firth column should be named Adv_ID (short for advisor ID), and have a data type of integer.