(i) mgr=null, ename=3rd character is N, not known anything else (ii) Give single example with sql queries for each of the following single-row functic CONCAT, INSTR, RPAD, TRIM? (iii) Write an sql query for: SAL not greater than 3000 and JOB has third character “A" in the string and h commission. (iv) Display employee record before 20-APR-1985. (v) Display only names and salaries of those employees whose salary is between 2000.

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: Execute the SQL statement. SELECT count(*) as "Total Customers" FROM customers; SELECT…

A: SELECT count(*) as "Total Customers"FROM customers;   SELECT count(distinct category_name) as…

Q: Please see the attached sql function question requiring an sql function to be written to calculate a…

A: alter session set plsql_code_type=native; CREATE FUNCTION mortgage_rate( p_principal…

Q: Difference between count (*) and count (col_name). Explain with an example.

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

Q: Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in…

A: The given PL SQL program uses a cursor to process a multi-row query. A cursor is  a work area which…

Q: SELECT TO CHAR (DOB, 'DD/YY/MM') FROM patients WHERE Medical_no=1001;

A: Given: select TO_CHAR(DOB,'DD/YY/MM) from patients WHERE Medical_no = 1001.   Explanation this is…

Q: Write function which hides the first_name, middle name and last_name and gives the joined version */

A: Find the required answer given as below :

Q: SELECT MAX(datediff(minute,start_time,end_time)) as "Longest_ride",…

A: Your SQL code contains error related to function datediff.

Q: a) Write an SQL query to find the manufacturer and model for all aircraft models with capacity at…

A: a)   SELECT Manufacturer , Model       FROM  Aircraft_Models       WHERE  Capacity>=300 ;   b)…

Q: Examine this executable section of a PL/SQL block: BEGIN FOR worker_record IN pay_cursor LOOP Worker…

A: PL/SQL is a combination of SQL and the procedural  languages  Developed by oracle  above question…

Q: Question 7 Writes a PL/SQL function that calculates the factorial of a number passed as a parameter.…

A: I give the PL/SQL code along with its output screenshot

Q: We have employee table contains (emp-no, emp-name, emp-age, emp-salary, emp-department) write a…

A: Given Employee table contains the attributes: emp_no, emp_name, emp_age, emp_salary, emp_department

Q: Question 11. Write the SQL statement that will implement the relational algebra expressions in the…

A: The queries are given below

Q: Given the following SQL query: Student (sid, name, age, address) Book (bid, title, author) Checkout…

A: Answer : The physical query plan for the above query. Assumptions: No indexes and data is not sorted…

Q: . Write SQL statements to create a table named STUDENT, with the following columns: StdID:…

A: In this question we have to write SQL QUERY for the given table name STUDENT.Let's query and hope…

Q: 154 -- Figure out and return for each employee the gender based on the title of courtesy 155 Ms.,…

A: In modern database management systems, it's often required to derive insights or information from…

Q: What does the following SQL query appear to do? SELECT category_name FROM categories WHERE…

A: The given SQL query selects the names of all categories that do not have any products associated…

Q: Code three tests: 1) for a student who has courses 2) for student who does not have courses 3) a…

A:

Q: Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in…

A: Ans:) In this PL/SQL block there are some errors in the syntax. The correct syntax for the…

Q: Write an sql query to show country code, country name of those employees whose country name…

A: Please refer below for your reference: Queries: 1.SELECT country code, country name FROM employees…

Q: Assume that the above diagram is a partial EER model representing the seat booking system of Virgin…

A: Find the required SQL queries given as below :

Q: Write a SQL query that retrieves the names and email addresses of all students who are enrolled in…

A: Step 1: Create the table students with the attributes student_id, name, email, major, and…

Q: For the table definition below, write a SQL UPDATE statement that changes all annual salaries to…

A: UPDATE Worker  SET SALARY = SALARY / 12 ;

Q: Write inner join SQL query that find those employees who deals with customers of their cities.…

A:

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: Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in…

A: In PL/SQL cursors are used to store the data row-wise and can store multiple rows, which can be…

Q: „By using SQL language return the items and their total number of units that have been ordered…

A: We have to pick the items where item name is not Pen and sum of Units of each Item category

Q: construct a sql query that shows the parking spot number and location, as well as the name of the…

A: Intro construct a sql query that shows the parking spot number and location, as well as the name…

Q: (Consider table employees with the following colunms (EMPLOYEE ID, FIRST NAME, LAST_NAME , EMAIL…

A: Select CONCAT(M.First_Name,' ', M.Last_Name) as MANAGER_NAME , M.Department_ID from Employees E…

Q: Create table sales ( cust varchar(20), prod varchar(20), day integer, month integer, year integer,…

A: Answer

Q: Focus on Basic file operations, exception handling. Save a copy of the file module6data.txt (Below)…

A: Required python code given below:

Q: Write an SQL query to find all customers whose name (either last name or first name) contains…

A: The following SQL queries can be used to achieve various tasks related to data searching and…

Q: Write and execute a SQL query to list all patient numbers and encounter ids which do not have any…

A: Actually, SQL stands for Structured Query Language.