Using SQL (create and insert into).1. Create the following tables and their relationships.2. Populate with the shown data.tables are shown at the pic**Write the following queries:3. List all the information in the student table.4. List the acc_number for the student Tyler Lane (do not usehis student_id).5. List all student last first and last name whose accountstatus is active. (perform join in the where clause)6. List all student last first and last name whose accountstatus is inactive. (Perform join in the from clause).7. List the last and first names of all students whose balanceis greater than 10000. (join as you like)8.
OR
OR