LAB TASKS Question No. 1: Select the names of actors whose IDs are between 50 and...

 

Transcribed Image Text:

LAB TASKS Question No. 1: Select the names of actors whose IDs are between 50 and 150, or those whos last name starts with A. Question No. 2: Write a query to display the names of customers in the following format. SMITH, M JOHNSON, P WILLIAMS, L JONES, B BROWN, E DAVIS, J MILLER, M WILSON, S MOORE, M TAYLOR, D Question No. 3: Retrieve the information showing the details of each of the Films released uptil now in the format: *Film Academy Dinosaur was released in the year 2006* Question No. 4: Display the usernames and address_ids of customers in the Sakila database. Question No. 5: Write two queries using the Substring functions on sakila database. Deliverable Submit a Word document of the SQL queries using the screenshot to answer above-mentioned information when executed over MySQL Workbench. LAB TASKS Question No. 1: Select the names of actors whose IDs are between 50 and 150, or those whos last name starts with A. Question No. 2: Write a query to display the names of customers in the following format. SMITH, M JOHNSON, P WILLIAMS, L JONES, B BROWN, E DAVIS, J MILLER, M WILSON, S MOORE, M TAYLOR, D Question No. 3: Retrieve the information showing the details of each of the Films released uptil now in the format: *Film Academy Dinosaur was released in the year 2006* Question No. 4: Display the usernames and address_ids of customers in the Sakila database. Question No. 5: Write two queries using the Substring functions on sakila database. Deliverable Submit a Word document of the SQL queries using the screenshot to answer above-mentioned information when executed over MySQL Workbench.