Below are the table schema for Table actor, movie, and actor$\_$role:Table $1$:$$ actor$($AID$$ varchar$(8),$ name$$ varchar$(30),$ salary$$ numeric$(8,2))$ AID is the primary keyTable $2$:$$ movie $($MID$$ varchar$(8),$ title$$ varchar$(50))$ MID is the primary keyTable $3$:$$ actor$\_$role $($MID$$ varchar$(8),$ AID$$ varchar$(8),$ rolename varchar$(20))$ MID and AID together are the primary key$$ AID is a foreign key $$ MID is a foreign key$1.$ Write a sql statement to create a database called movieData. $(1$ point$)2.$ Write a sql statement to switch to database movieData. $3.$ Please specify the order of table creation $4.$ Please specify the order of data population of the tables $5.$ Write sql statements to create table actor$\_$role. Write queries in SQL for each of the following questions:$($Table:$$ actor$$ movie$$ actor$\_$role $)6.$ Find the average salary of actors $.7.$ Find actor Ians AID. $8.$ Find the names of all actors whose name includes the substring $\text{'}$au$\text{'}.9.$ Find all actors name who has had a role in movies $($Remove duplicates$).10.$ Find the MID of movie$$ 'Life is beautiful'.