Using MySQL and sakila table, definitions, and download found here:

https://dev.mysql.com/doc/sakila/en

1.Using the Sakila schema, produce two queries that identify the films each actor has been in. List the films title, films release year, and actors last name

a.Use implicit inner join syntax across three tables in the first query.

b.Use two explicit inner join syntax in the second query.

Result Set Size: 5462

2.Using the Company schema, provide a query that lists all employees along with any dependents. Include employees without dependents in the result set.

List the employee first name, last name, ssn, and the dependents name and relationship if a dependent exists.

Use the explicit joins.

Result Set Size: 47

3.Using the Company schema, select the unique project numbers and project names where either the project departments manager is Freed or an employees last name is Freed.

Use explicit join notation where necessary.

Result Set Size: 2

Nested selects may be needed in this case.

4.Using the Company schema, list every project name and average employee salary for employees in the project.

Use explicit joins.

Note that the avg salary for project 61 (OperatingSystems) is 42,166.

Result Set Size: 11