$(8)$ Write the SQL statement to create the database politics in PostgreSQL.

$(9)$ Write the SQL statement and create the table senators in database politics. Insert the initial data below into the table senators$.$

$\text{'}$AL$\text{'},$ 'Jeff Sessions', $\text{'}$R$\text{'},1997,1946$

$\text{'}$AL$\text{'},$ 'Richard Shelby', $\text{'}$R$\text{'},1987,1934$

$\text{'}$AK$\text{'},$ 'Mark Begich', $\text{'}$D$\text{'},2009,1962$

$\text{'}$AK$\text{'},$ 'Lisa Murkowski', $\text{'}$R$\text{'},2002,1957$

$\text{'}$AZ$\text{'},$ 'John McCain', $\text{'}$R$\text{'},1987,1936$

$\text{'}$AZ$\text{'},$ 'Jon Kxdl$\text{'},\text{'}$R$\text{'},1995,1942$

$\text{'}$AR$\text{'},$ 'John Boozwan', $\text{'}$R$\text{'},2011,1950$

$\text{'}$AR$\text{'},$ 'Mark Pryor', $\text{'}$D$\text{'},2003,1963$

$\text{'}$CA$\text{'},$ 'Barbara Boxer', $\text{'}$D$\text{'},1993,1940$

$\text{'}$CA$\text{'},$ 'Dianne Feinstein', $\text{'}$D$\text{'},1992,1933$

$\text{'}$CO$\text{'},$ 'Mark Udall', $\text{'}$D$\text{'},2009,1950$

$\text{'}$CO$\text{'},$ 'Michael Bennet', $\text{'}$D$\text{'},2009,1964$

$\text{'}$CT$\text{'},$ 'Richard Blumenthal', $\text{'}$D$\text{'},2011,1946$

$\text{'}$CT$\text{'},$ 'Joe Lieberman', $\text{'}$D$\text{'},1989,1942$

$\text{'}$DE$\text{'},$ 'Thomas Carper', $\text{'}$D$\text{'},2001,1947$

$\text{'}$DE$\text{'},$ 'Chris Coons', $\text{'}$D$\text{'},2010,1963$

$\text{'}$FL$\text{'},$ 'Bill Nelson', $\text{'}$D$\text{'},2001,1942$

$\text{'}$FL$\text{'},$ 'Marco Rubio', $\text{'}$R$\text{'},2011,1971$

$\text{'}$GA$\text{'},$ 'Saxby Chambliss', $\text{'}$R$\text{'},2003,1943$

$\text{'}$GA$\text{'},$ 'Johnny Isakson', $\text{'}$R$\text{'},2005,1944$