i need help with my views and sequences in my sql /* Create 2 views */ /*show the first and last name of people located in maryland*/ CREATE VIEW

i need help with my views and sequences in my sql

/* Create 2 views */

/*show the first and last name of people located in maryland*/

CREATE VIEW spender_identity AS

SELECT firstname, lastname

FROM spender

WHERE location = 'maryland';

/* Show the cost and person who paid rent*/

CREATE VIEW housing_cost AS

SELECT housing_item, spendernam

FROM Housing

WHERE housing_item = 'rent';

/* Create sequence*/

CREATE SEQUENCE Spender_seq

 START WITH 1

 INCREMENT BY 1;

CREATE SEQUENCE Spender1_seq

   START WITH -1

   INCREMENT BY -1;