1.
CREATE TABLE Senators (
  Name varchar(255),
  State varchar(255),
  Affiliation varchar('D', 'R'),
  Age int
);

2.
INSERT INTO Senators VALUES ("Barack Obama", "Illinois (IL)", "D", 54);
INSERT INTO Senators VALUES ("John McCain", "Arizona (AZ)", "R", 79);
INSERT INTO Senators VALUES ("Paul Rand", "Kentucky (KY)", "R", 52);
INSERT INTO Senators VALUES ("Tom Cotton", "Arkansas (AR)", "R", 38);
INSERT INTO Senators VALUES ("Dianne Feinstein", "California (CA)", "D", 82);

3.
(3) SELECT Name, State FROM Senators;
(5) SELECT Name, Age, State FROM Senators WHERE Age < 40;
(6) SELECT Name, Age, State FROM Senators WHERE Age > 80;
(7) SELECT Name, Age, State FROM Senators WHERE Affiliation = "D";
(8) SELECT Name, Age, State FROM Senators WHERE Affiliation = "R";
(9) SELECT Name, Age, State FROM Senators WHERE Age >= 50 AND Age <=60;

4.
INSERT INTO Senators VALUES ("Flip Flop", "Flip-Flopia (FF)", "D", 50);
INSERT INTO Senators VALUES ("Ben Button", "Ben-Buttonland (BB)", "R", 70);
INSERT INTO Senators VALUES ("Ben Flop", "Flip-Buttontown (FB)", "R", 70);

UPDATE Senators SET Affiliation='R' WHERE Name='Flip Flop';
UPDATE Senators SET Age=40 WHERE Name='Ben Button';
UPDATE Senators SET Affiliation='D', Age=40 WHERE Name='Ben Flop';

5.
DELETE FROM Senators WHERE Name='Barack Obama';
DELETE FROM Senators WHERE Age = 40 OR Age = 50;
DELETE FROM Senators;
DROP TABLE Senators;