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

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_update

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!