The HR department needs a report to display employee information as shown from the job_history table. The months worked is the number of months from the start date to the end date. Only list those employees whose months worked is an even number. Order by months worked descending

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: Q6) how much is the total customer balance ? Q7) what is the minimum price for each sale code?

A: SQL QUERY:  Select SUM(CUS_BALANCCE) AS [Sum of Balance] From Customer  Group by CUS_CODE.

Q: Based on the ERD below, display Employee first name, middle initial and last name so it displays in…

A: In this case, the whole name is displayed in a single column of employees where the job code is…

Q: True or False Each column in a table must have a name.

A: Each column in a table must have a unique name. The entries within each column should match with…

Q: 7. For each project, display project name, project platform, project cost and total number of…

A: In sql, we use SELECT statement to display the table details according to the requirement. We will…

Q: Using software.subscriptions table, pull all columns for subscriptions that have been cancelled.

A: The query to pull all columns for subscriptions that have been cancelled from the…

Q: PRODUCTS PID DESC PRICE SID QTY 801 Pencil 3 1 10 802 A4 6 2 15 803 Ballpen 4 2…

A: GIVEN: PRODUCTS PID DESC PRICE SID QTY 801 Pencil 3 1 10 802 A4 6…

Q: List the names and number of employees supervised (label this value HeadCount) for each supervisor…

A: List  the  nаmes  аnd  number  оf  emрlоyees  suрervised  (lаbel  this  vаlue  HeаdСоunt)  fоr  eасh…

Q: Rank Normal forms where each form is a subset of the form above it. [ Select) [Select First Normal…

A: We are going to arrange Normal forms in the database.

Q: explaining why Column chart type selected and why this type was chosen. What is column chart

A: A column chart is a type of chart used to visualize data in the form of vertical columns. Each…

Q: Find your own open numerical statement (with the universe of positive integers), P(x, y) and Q(x)…

A: Solution p(x,y)  &  Q (x) we can assume  p(x,y)   ->  xy  Q (x)    ->  x  p(x,y)   ->…

Q: Q9) find the least expensive price Q10) List the UNIQUE v_code of vendors that provide products Q11)…

A: A relational database contains tables. Tables are also known as relations and they contain tuples…

Q: 9. Find the total amount of tax paid by resident of NJ Hint: The tax cost stored in tax_amount…

A: Inner join is used to join two tables. Tax_amount column is given , to find sum value of a column.…

Q: Count the number of different professors names.

A: DISTINCT is the keyword used to get the different names and then COUNT is applied

Q: Part II: Complete the following exercise:    Using a subquery, select student first name where the…

A: As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…

Q: Based on the array named B in the figure below, write the Quick sort partition work trace for cut =…

A:

Q: I. Retrieve the SSN_NUMBER of all employees whose name starts with N. Attribute First Name Last Name…

A: Given: To write the SQL query.

Q: Item Number (Item Name) In this case, the date of supply is 04 VENDOR Vendor supply chain Authors'…

A: Attribute (Simple): Simple qualities are ones that cannot be further subdivided. For example, in the…

Q: Classify students according to the total number of hours they have completed. (Less than…

A: Note:- There are multiple hours completed columns, two are visible in the first screenshot, assuming…

Q: Q14) how many products with price < 10

A: You have asked multiple questions so we will solve the first one for you. If you want any other…

Q: Q1- List all employees whose job_id is IT_PROG and hired after 01-JAN-95 and earning more than 5000.…

A: Let the table name be emp which has the following columns   employee_id, first_name, last_name,…

Q: List the names of all Staff members who hold a faculty position and have a salary of $45,000 or…

A: SQL Space: To leave the space while displaying the data ,a function called space is used. Syntax:…

Q: Display the total number of credits earned in each year using the tot credits (year, num credits)…

A: To explain this, we will assume that we have the following two tables:

Q: Table Employee (eid,ename, manager_id,edptid) Show employee with his/her manager name.

A: TableEmployee(eid,ename, manager_id,edptid)Show employee with his/her manager name.With the help of…

Q: Assume the PRODUCT table contains multiple rows. The following code would include: SELECT…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: SQL DML/DDL  There are five tables describing employees of a company, departments, buildings, which…

A: Creating tables and inserting values: create table Employee (EID number primary key, Ename text,…

Q: a) Write in SQL a command that creates the table Products according to the above description (2…

A: Introduction: The syntax to create a table is shown below. CREATE TABLE table_name (    column1…

Q: Find the names of the pilots who are not certified to fly the aircrafts in the flight table. Sort…

A: We have to find the names of the pilots who are not certified to fly the aircraft in the flight…

Q: Row trigger that gives the sum total before insert or update using sql

A: Find the required trigger given as below :

Q: list the last name and salary of employees who earn between $5,000 and $12,000, and are in…

A: list the last name and salary of employees who earn between $5,000 and $12,000, and are in…