Write the SQL code required to add Jane Doe to the CUSTOMER table as an active residential customer (as opposed to a business customer) and member to the CSS Theater club with a 10% discount (do not need to create records in the address or phone tables).

Transcribed Image Text:

address PK address id varchar(10) FK1 customer_id addr_type address 1 address2 city state postal status varchar(10) varchar(15) varchar(15) varchar(15) varchar(15) char(2) varchar(9) char(1) PK screen_id FK1 theatre_id PK customer_id customer_type first_name last_name initial email screen customer screen_number screen_cap status res_member_flag char(1) res_discount int bus_account_num varchar(10) bus_company status varchar(25) char(1) varchar(10) varchar(10) int int char(1) PK phone_id varchar(10) FK1 customer_id varchar(10) varchar(15) phone_type phone_nbr char(10) status char(1) varchar(10) varchar(15) varchar(25) varchar(25) char(1) varchar(50) phone PK list_id lov varchar(10) ticket_order PK order_id FK1 customer_id FK2 show_id quantity unit_price smallmoney date_created datetime varchar(10) varchar(10) varchar(10) show PK show_id FK1 screen_id FK2 film_id int created_by date_modified datetime modified_by varchar(10) price status varchar(10) varchar(10) varchar(10) varchar(10) show_date datetime show_time datetime seat_open int smallmoney char(1) address PK address id varchar(10) FK1 customer_id addr_type address 1 address2 city state postal status varchar(10) varchar(15) varchar(15) varchar(15) varchar(15) char(2) varchar(9) char(1) PK screen_id FK1 theatre_id PK customer_id customer_type first_name last_name initial email screen customer screen_number screen_cap status res_member_flag char(1) res_discount int bus_account_num varchar(10) bus_company status varchar(25) char(1) varchar(10) varchar(10) int int char(1) PK phone_id varchar(10) FK1 customer_id varchar(10) varchar(15) phone_type phone_nbr char(10) status char(1) varchar(10) varchar(15) varchar(25) varchar(25) char(1) varchar(50) phone PK list_id lov varchar(10) ticket_order PK order_id FK1 customer_id FK2 show_id quantity unit_price smallmoney date_created datetime varchar(10) varchar(10) varchar(10) show PK show_id FK1 screen_id FK2 film_id int created_by date_modified datetime modified_by varchar(10) price status varchar(10) varchar(10) varchar(10) varchar(10) show_date datetime show_time datetime seat_open int smallmoney char(1)