Experts answer please. just answer two questions

Please list out the SQL queries to perform the following.

(for each question, please list the question, the SQL query together with screenshot ( first 5 rows , or simply result in text mode)

1. Write a query that finds, for each customer X, another customer Y who has rented at least one movie in common with X. Find all such pairs of Customers (X, Y) and against each pair, the number of overlapping movies. Order the results by the number of overlapping movies in descending order. The query should thus have these columns. customer X first_name, customer X last_name, customer Y first_name, customer Y last_name, nOfOverlabMovies
2. Write a SQL statement that generates a a list of actors whose movies have been rented out the most in the recent most year of the data.

https://dev.mysql.com/doc/index-other.html

Nand a , X X each Allah nert SklaXAMP.pdf / 295 KHI Feb & Duchon updated wilt mote clarifications. Reler below In this assignment we are going to be using MySQL (not SOL server) Nso, we are going to use a new DB, called 'Sakilal database. It can be downloaded from https:/dey.myscl.com/doc/indexother.html En Extending My 57 We USM Commande Tool FC Engi Landing 56 Ve USA Tot Eng SOL mama Ada stract Test View USLIM CE | ail- do (apiritut- Example Databases wali Title Download Jud chama wird database amp TOZ alla data 162 TOZ Once you download the zip file for Sakila, it gives you two files (as seen) You need to later import them to your phpMyAdmin (or anything else) ane by one. You can watch the video shared about XAMPP installation which installs phpMyAdmin for you Step 1 - Crate a DB and name a Sakila Step 2 - Import sila shema sal to the Sakita DB to create tables Step 3 row that the empty tables are created, you want to insert data into them. So, import Sakila data sal which is full of thousands of insert SOL statement to fill up there with thousands of rows of data Check import_Saki_XAMPP.pdf (attched) for more If you don't have phpMyAdmin the Sakila DB can also be installed using instructions: https://dev.mysticum doc sakilale sakila-instalation.html Submit or low your wat placed with cord Please let out the SQL queries to perform the following. (for each question, please let the question, the SQL query together with screenahot (first 5 rowe, or simply result in text mode) 1. customer X first_name, customer X laat_name, customer Yfirst_name, Y Movies 2. Write a SOL statement that generates a a list of actors whose movies have been rented out the mos, in the recent most year of the data Please state your assumptions dearly, . Put your names and ID at top of the assignment (no need to create a blank front page) For each question, post the question then the SOL statement in text underneath it then the screenshot of first rows (max) or the result in text ro Nand a , X X each Allah nert SklaXAMP.pdf / 295 KHI Feb & Duchon updated wilt mote clarifications. Reler below In this assignment we are going to be using MySQL (not SOL server) Nso, we are going to use a new DB, called 'Sakilal database. It can be downloaded from https:/dey.myscl.com/doc/indexother.html En Extending My 57 We USM Commande Tool FC Engi Landing 56 Ve USA Tot Eng SOL mama Ada stract Test View USLIM CE | ail- do (apiritut- Example Databases wali Title Download Jud chama wird database amp TOZ alla data 162 TOZ Once you download the zip file for Sakila, it gives you two files (as seen) You need to later import them to your phpMyAdmin (or anything else) ane by one. You can watch the video shared about XAMPP installation which installs phpMyAdmin for you Step 1 - Crate a DB and name a Sakila Step 2 - Import sila shema sal to the Sakita DB to create tables Step 3 row that the empty tables are created, you want to insert data into them. So, import Sakila data sal which is full of thousands of insert SOL statement to fill up there with thousands of rows of data Check import_Saki_XAMPP.pdf (attched) for more If you don't have phpMyAdmin the Sakila DB can also be installed using instructions: https://dev.mysticum doc sakilale sakila-instalation.html Submit or low your wat placed with cord Please let out the SQL queries to perform the following. (for each question, please let the question, the SQL query together with screenahot (first 5 rowe, or simply result in text mode) 1. customer X first_name, customer X laat_name, customer Yfirst_name, Y Movies 2. Write a SOL statement that generates a a list of actors whose movies have been rented out the mos, in the recent most year of the data Please state your assumptions dearly, . Put your names and ID at top of the assignment (no need to create a blank front page) For each question, post the question then the SOL statement in text underneath it then the screenshot of first rows (max) or the result in text ro