Question: Use the above sakila database structure to answer the following queries. Must write your queries in a paper and insert its snap. 1. Create 'Customer'

Use the above sakila database structure to answer the following queries. Must write your queries in a paper and insert its snap. 1. Create 'Customer' table. Customer_id is an auto increment field. Make sure to add primary key and foreign key constraints. 2. Show customer_id, first name and last name of all those customers whose name start with 'H'. 3. Remove last_update field from customer table. 4. Add a field named dob whose data type is date to customer table. 5. Display customer_id, first_name, last_name, email of all customers who were added between 01- 01-2021 and 01-04-2021. 6. Add a customer whose first name, last name and email is Muhammad, Asim, masim respectively. 7. Display all addresses and postal_codes of Rawalpindi (Pakistan) district. 8. Display title of all those films whose renatl_rate is more than $3. 9. Change first name and email address of a customer to Iqbal and iqbal_khan whose id is 130. 10. Delete country table.
Es actor city 123 city_id ABC City 12 country_id last_update country 123 country_id ADC country last_update 123 actor_id ABC first_name Alast_name last_update film_actor 123 actor_id 123 film_id last_update 1 address 123 address_id ABC address ABC address2 ABC district 12 city_id ABC postal code ABC phone last_update customer 123 customer_id 12 store_id ABC first_name As last_name ABC email 12 address_id 123 active create_date last_update store 123 store_id 123 manager_staff_id 12 address_id last_update film 123 film_id A title ABC description release_year 123 language_id 122 original_language_id 123 rental_duration 123 rental_rate 123 length 123 replacement_cost ABC rating ABC special_features last_update inventory 123 inventory_id 123 film_id 123 store_id last_update 3 rental language 123 language_id ABC name last_update film_category 123 film_id 123 category_id last_update 123 rental_id rental_date 123 inventory_id 12 customer_id return_date 123 staff_id last_update category 123 category_id ADC name last_update staff payment 123 payment_id 12 customer_id 123 staff_id 12 rental_id 123 amount payment_date last_update 123 staff_id ABC first_name ADC last_name 123 address_id e picture ABC email |123 store_id 123 active ADC username ABC password last_updateStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
