I am trying to find the average of data and Floor the results. How would you use AVG and FLOOR function together?

Q: Create a Procedure in PL/SQL takes employee_id, rate_salary, rate_commission. This function will…

A: Find the required procedure in PL/SQL given as below :

Q: What did each card cost? Show the card number, player last name, team name, price, price with 5%…

A:

Q: How does the RANK function distinguish itself from the DENSE_RANK function in SQL?

A: In SQL, both the RANK and DENSE_RANK functions are used for ranking rows within result sets based on…

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

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

Q: BOOK_NUM Times Checked Out BOOK_NUM TIMES Checked Out 5236 12 5236 12 No under score line 5235 5235…

A: SELECT  BOOK_NUM, COUNT(check_out_DATE) AS "Times Checked Out " FROM  CHECKOUT GROUP BY BOOK_NUM…

Q: Just let me know what to write for the SQL theory: Question:  Write a query to display the first…

A: Solution:   Given,

Q: Write the T-SQL scripts for the following tasks: - Write a query to list all the Employee's details…

A: let us see the answer:- Introduction:- We are going to use a select query to list all the Employees…

Q: How do scalar functions and table-valued functions differ in SQL, and when might each be preferred?

A: User-defined functions are adaptable tools for encapsulating logic and boosting query capabilities…

Q: Write SQL queries to answer the following questions:a. Which studen ts have an ID number that is…

A: SQL queries are given below

Q: Use CASE statement in PL SQL block, where take a character as input from the user and print…

A:

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: Given the table customers which contains columns customer_id, first_name, last_name, and state, and…

A: SELECT C.LASTNAME, A.STATE, A.ZIP FROM CUSTOMER AS C INNER JOIN ADDRESS AS A on…

Q: Write the T-SQL scripts for the following tasks:   Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: Write SQL code that will return the total number of hours worked for each employee and the total…

A: SQL code: The COUNT function calculates the number of numeric values in a list of inputs. COUNT…

Q: I need help figuring out the SQL quereys for the questions above using table joining method.  1)…

A: Please refer to the following step for the complete solution to the problem above.

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

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

Q: How do I create a query that includes first name, last name, email and state for all customers and…

A: Query:-   SELECT first_name, last_name, email, state, CASE WHEN customer_type = 'Customer' THEN 'C'…

Q: In the following PL/SQL block, determine the values and data types for each of the following cases:…

A: conclusion:In the nested block:v_customer holds a numeric value of 201 with a data type of…

Q: Customer(cid,name,surname,city,address,phone); Account(aid,cid,amount,created,comment);…

A: - We need to write a sql query to get the names, surnames and phone number according to the transfer…

Q: Write a query to produce the total number of hours round to 1 digit and charges round to  2 digits…

A: The Sql Query corresponding to the above problem is solved as :   SELECT Proj_Num,…

Q: I was wondering if you could do this in PL/SQL format. declare begin  end; etc

A: DECLARE The user must declare any variable before using it in a batch or method. The memory…

Q: Write a SQL code that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in…

A: The question is solved in step2

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: Use %ROWTYPE for your cursor. You will use 3 tables in this activity – departments, locations, and…

A: It is defined as a combination of SQL along with the procedural features of programming languages.…

Q: How does the RANK() function differ from DENSE_RANK() in SQL when ranking data?

A: Data ranking in SQL is accomplished using both the RANK() and DENSE_RANK() methods. They are…

Q: Write SQL code that will return the total number of hours worked for each employee and the total…

A: Assignment: An assignment is a task that you have been given by someone in authority. The term…

Q: Using My SQL Workbench Find all cities in Argentina whose name begins with S or M a. display city…

A: Logic:-  To display names that begins with any character , use like operator and put first character…

Q: Select clause and from clause: Display the columns specified above in the problem  statement from…

A: Write a query to display the author ID, first name, last name, and year of birth for all authors…

Q: by using the table in the query attached: Show the name, contact number and email address of the…

A: Demo data has been used to solve the query The SQL query is given below with output screenshot

Q: Customers Customer ID Last Name C0001 Faulkner C0002 Wit Loan Id L0010 L0017 L0016 Customer Total…

A: CustomerID Last Name Loan ID Amount   C001 Faulkner L0010 200000       L0017 100000…

Q: „By using SQL language return the

A: According to the question we need to return the items and their total number of units that have been…

Q: Create a PL/SQL function to increment the salary of all employees of an organization by 15%, and for…

A: Creating a PL/SQL function to increment the salary of all employees of an organization by 15%, and…

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: Create a PL/SQL query to display the invoice number, coin name, coin price and delivery notes. In…

A: We have to Create a PL/SQL query to display the invoice number, coin name, coin price, and…

Q: Create a procedure in PL/SQL takes Department Id and return record data type has maximum salary,…

A: Find the required procedure in PL/SQL given as below :

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: In the preceding PL/SQL block, determine the values and data types for each of the following cases.…

A: PL/SQL block, the values and data types for each of the following cases are:   a) The value of…

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

A: Answer

Q: Which restaurant id had the highest number of orders placed in June 2021?   Write SQL code, The…

A: To determine which restaurant had the highest number of orders placed in June 2021, you can use the…

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.