Tables: t1- actor ( AID varchar(8), name  varchar(30), salary numeric(8,2)) t2- movie ( MID  varchar(8), title varchar(50)) primary key MID t3-actor_role (MID varchar(8), rolename varchar(20)) write queries in SQL to answer each of the following questions: (Table: actor  movie  actor_role) 1. Find the average salary of all actors. 2, Find the actor IAN's AID. 3. Find the names of all actors whose name includes the substring 'au'. 4. Find all actor's name who has had a role in movies (remove duplicates). 5. Find the MID of movie 'Life is Beautiful'.

Q: Display the list of students who are involved in the IT club Display the details of all the…

A: First get the studid from Club table and then get those Student details This can be done using inner…

Q: in pl /sql the commend is like this  create table bb_basketstatus (idstatus number, idbasket…

A: The answer for the given question is as follows.

Q: in pl/sql ,use Cursor to get all the records from table  job_history for employee_id 121

A: pl/sql code for the above question is solved in step 2:- assume table job_history has columns…

Q: nt database. The primary keys are highlighted in bold. Student (studNo, studName, address,…

A: Below is part of a Student database. The primary keys are highlighted in bold. Student (studNo,…

Q: What are the considerations for using the CAST and CONVERT functions for data type conversions in…

A: In the world of SQL (Structured Query Language), data type conversions are a fundamental aspect of…

Q: How does the CONCAT_WS function provide advantages over the traditional CONCAT function in SQL?

A: CONCAT_WS function is an SQL function that is used to add two or more strings together with the…

Q: How does the COALESCE function compare with the ISNULL function when handling NULL values in SQL

A: The COALESCE and ISNULL functions are both used to handle NULL values in SQL. However, they have…

Q: LETTER GRADE( PI) VARCHARI2) NOT NULL GRADE POINT MAX_GRADE MN_GRADE CREATED_BY CREATED DATE…

A: a) From which two fields in which table can you calculate the enrollment of a section? ans:…

Q: In Sql These are some database from a set of tables insert into AccountHolder(AccountID,…

A: In this database scenario, we have a collection of tables representing an imaginary banking system.…

Q: The following figure is part of a university database. LNAME and FNAME stands for last name and…

A: Project operation (denoted by pi (∏) symbol) is used to select desired columns (or attributes) from…

Q: help with sql class  2 questions  1. Report the names of all authors and the title_name of the…

A: Let's see the answer:

Q: What is the purpose of the Like operator in SQL?

A: Purpose of Like operator in SQL:   In SQL, “Like” operator is used for comparing the similar…

Q: n sql, an associate array is a table that is associated with a / an

A: Associate array in SQL An associative array, also known as an index-by table, is said to be a set…

Q: help with sql class 7. For each book, list the book name, the author name, and the publisher's…

A: Given: Determine the SQL queries to identify. a) For each book, list the book name, the author name,…

Q: What are the advantages of using table-valued parameters in SQL functions

A: Table-valued parameters (TVPs) in SQL are a powerful feature that allows developers to send multiple…

Q: Below is part of a Student database. The primary keys are highlighted in bold. Student (studNo,…

A: Given to write a  PL/SQL PROCEDURE that will list the project names given the course ID. The below…

Q: Complete PL/SQL function below, which will return last name of employee whose id is equals to 2…

A: The above question is solved in step 2:-

Q: Write PL/SQL or T-SQL procedures to accomplish the following tasks: A: obtain the name and credit…

A: Actually, SQL stands for Structured Query Language.

Q: Write the syntax for AUTO_INCREMENT in sql databases.

A: Question. Write the syntax for AUTO_INCREMENT in SQL databases. Answer. AUTO_INCREMENT:…

Q: Write the SQL code necessary to create the table defined in the picture below:

A: We have to write the sql code for the given table. we have been given products table we have to…