Q.1: Write SQL queries, using "Movie Rental Database" schema to extract following information i. Give all the customers who lives in Hamilton. Display customer_id and customer_name. ii. Display the...

Write SQL queries, using "Movie Rental Database"

Extracted text: Q.1: Write SQL queries, using "Movie Rental Database" schema to extract following information i. Give all the customers who lives in Hamilton. Display customer_id and customer_name. ii. Display the total payment are received by each employee, and sort by empsin. iii. Display the total movies are rented out by each store, and sort by storeid. Display all the tapes are never rented out in every store, and sort by movieid & tapeid. Display all customers who did not rent any movie so far and sort by custid. Display the total amount received by different payment type, and sort by ptdesc. Display the number of movies rented out based on the movie rating, and sort by rating. viii. Display top 5 customers based on their total payment, and sort their total payment iv. V. vi. vii. decreased. List all the movies customer rented. Please display the columns: movie title, rental status, rental_rate, rental_employee, the employ accepts the payment, payment_type and payment_status. List all the manager's name and the name of employee they manage. Please sort by manager sin & employee sin. ix. х.