Please help me for this mysql Assignment-- so the query should be a mysql query. thank you in advance

Last Chance College Database Creation Lab Value: 20 Points 1. Create a database named LAST CHANCE COLLEGE 2. Create a table named STUDENTS. Use the information below to develop the table. Table Row Name STU_ID STU_FIRST_NAME STU_LAST_NAME ADDRESS CITY STATE ZIP MAJOR Data Type CHAR CHAR CHAR VARCHAR CHAR CHAR CHAR CHAR 3. Start the TEE logging command to store your work in a file name LCC.txt 4. Use the SOURCE command to import the database file. 5. Use the SHOW command to view all the tables. 6. Use the DESCRIBE command to view the table structure. 7. Check for errors and submit the LCC.txt file