Create the following three VIEWS: Create a VIEW which lists the total number of tornado track records for each state d

[answerhappygod]

Create the following three VIEWS: Create a VIEW which lists the total number of tornadotrack records for each state during the time interval2000-2015. (Requirement: Create VIEW)Create a second VIEW which lists the number of mobile homeunits in each state. (Requirement: CreateVIEW)Create a third view which lists the total number of tornadofatalities in each state. (Requirement: CreateVIEW)Note: The column named fat in the tornado trackdata lists the total number of fatalities, and thecolumn st specifies the state associated witheach record.List the five U.S. states in order which contain the largestnumber of LARGE mobile home parks. (Requirement:Answer question. Provide query.)List the five U.S. states in order which have had the greatestnumber of fatalities due to tornados from 1950 to 2015. Include thetotal population for each state in the resultingtable. (Requirement: Answer question. Providequery.)Note: The column geo_stusab in the population data specifies thestate by abbreviation.