University AAA has 150 staff which consists of an academic and a non-academic category. Each staff is given an option to select either a PENSION ON 56 YEARS scheme or a PENSION ON 60 YEARS scheme. Display the details of each staff information and the total number of academic staff and non-academic staff that have selected a PENSION ON 56 YEARS scheme and a PENSION ON 60 YEARS scheme. You are required to get an output as shown in Figure B

Q: Provide a summary of customer balance characteristics for customers who made purchases. Include the…

A: Actually the given information is Minimum Balance 0.00 Maximum Balance 345.86 Average Balance 70.30

Q: WEB Development Lab Final exam 7/July/2021 Q) Create a SQL data base containing a table concerned…

A: Command to create database family and opening database named family Command to create table named…

Q: Based on the ERD below, display the assignment number, employee number and assigned hours for either…

A: Here we are joining three tables ASSIGNMENT, EMPLOYEE, and JOB and the assigned job is either 501 or…

Q: Use the sample output below as a reference to compile a list of every purchase made by customers.…

A: Query: SQL The SQL code for putting the results in order by invoice number, product description, and…

Q: In cell D5, construct a formula to calculate the % of Total Projected Investments for Pooled…

A: According to the information given:-We haev to define above scenario in excel.

Q: Task 12: List the item ID, description, and category for each pair of items that are in the same…

A: Creating table ITEMS: create table ITEMS(item_id varchar2(5) Primary Key,Description…

Q: From the employee table, calculate the average compensation for each job category where the employee…

A: here is the the required SQL query as shown below :-   SELECT     -- columns to be retrieved     JOB…

Q: On the Calc sheet, in cell C11, use the AVERAGEIFS function to determine the average gross revenue…

A: The AVERAGEIFS function in Excel calculates the average of a range of cells based on multiple…

Q: Write the following constraint in correct form with a number for the RHS. Supervisory labor hours…

A: Write the following constraint in correct form with a number for the RHS. Supervisory labor hours…

Q: FIRST NAME LAST_NAME SALARY John Russell 14000 .4 Karen Partners 13500 .3 Alberto Errazuriz 12000 .3…

A: NOTE: Here student mentioned list employee managed by each manager. so here I am using manager id to…

Q: Each employee just have one meeting per week. Your code, for example in week 2, let employee 2 has 2…

A: The given Python program is as follows: employees = ["employee_1",             "employee_2",…

Q: aC program to enter the midterm marks of 4 courses for 3 students. Calculate the average mark for…

A: For this program, the concept of parallel arrays will be used. Algorithm for writing the program is…

Q: Customer (CID, CName, Street, City, State, Gender) Agent (AgentID, GName, Position, Salary, Gender,…

A: Query the Customer table and order by city and state. Add Distinct keyword to get the unique city.…

Q: Normalize the following table to 3NF. 4 PK StudentNo CourseID StudName | GradeReceived StudCity…

A: Dear Student, In 3NF form the table must not have any transitive dependency , all dependency must be…

Q: se are the frequent item S sample transactions,

A: To find, Provide support values Provide confidence values Provide lift values Discuss on the…

Q: Given the employees of medium-sized semi-conductor firm, find the employee that joined November 8,…

A: The Excel INDEX function returns a value in an array based on the row and column numbers you…

Q: please code this in SQL Language

A: The database generation code in mysql is provided below:

Q: Table Schema: Amazon_Item (P#, P_NAME, SELL_PRICE, QTY) Amazon_Supply (S#*, P#*, SUP_PRICE)…

A: We have to develop a SQL code to find the find the supplier number, supplier name and their minimum…

Q: all the related employee attributes for those employees whose salary is above 5000

A: all the related employee attributes for those employees whose salary is above 5000

Q: Change to use the database frozenfood Alter table customerOrder add column total as data type…

A: Note: As per our guidelines we can able to solve only three questions. So, please re-post the…

Q: Question 14 We want to select all employees from a table named EMPLOYEE for employees whose last…

A: ANSWER : Option: c We want to select all employees from a table named EMPLOYEE for employees whose…

Q: Suppose we have two tables. One table is Supplier with column supplieriD and ItemiD. The other table…

A: Here there are multiple questions so I have answered 1st questions below. If you want other…

Q: The latest scores from the Japanese Baseball League are in the table with schema Scores(Team, Day,…

A: A query is a request or command to retrieve or manipulate data from a database. It is a statement…

Q: Translate your ER diagram into the form of SQL DDLs. Choose appropriatedata types for each attribute…

A: 1. Develop a logical information model for each known user combined structure for the application…

Q: 2. 3. Which of the following is true of GROUP BY clauses? (Select all that apply.) a). GROUP BY…

A: group by clause is used to group columns so that aggregate operations can be performed on them.…

Q: Find the listing of customers who did not make purchases during the invoicing period. Sort the…

A: SQL: SQL (Structured Query Language) is a programming language used to manage and manipulate data in…

Q: SQL query database result

A: Problem Statement for SQL: The HR manager wants to calculate total salaries and count of only…

Q: 1 2 3 4 Name Blake James King Allen City Fee Saida 2850 300 1100 1300 Saida Zahle Beirut What is the…

A: As per our guidelines, we are supposed to answer only one question. Kindly repost the remaining…

Q: Check the following statement: select sysdate Today, (select count (*) from departments)…

A: Solution :