1. Display the last name and salary for all employees whose salary is not in the range of $5,000 and $12,000.  2. Display the employee last name, job ID, and start date of employees hired between February 20, 1998, and May 1, 1998.  3. Display the last name and salary of employees who earn between $5,000 and $12,000, and are in department 20 or 50.  4. Display the last name, job, and salary for all employees whose job is sales representative or stock clerk and whose salary is not equal to $2,500, $3,500, or $7,000. 5. Display the last name, salary, and commission for all employees whose commission amount is 20%.  Note: this question is related from database subject.

Q: Task 4: Use the IN operator to find the ID, first name, and last name of each customer for which as…

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

Q: In cell C16, enter a formula to calculate the price of the vehicle minus your available cash (from…

A: Cell references in Excel that don't change when they are copied or filled in are known as absolute…

Q: During the month of January, an employer incurred the following payroll taxes: FICA Social Security…

A: Debit Payroll Tax Expense: $819 Credit FICA Social Security Taxes Payable: $372 Credit FICA…

Q: Create a NONCAT table with the structure shown in Figure 6-28. Insert into the NONCAT table the item…

A: - We need to create a NONCAT table.

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: 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: Write a SELECT statement that joins the Departments, Courses, and Instructors tables. This statement…

A: To achieve this using a SQL SELECT statement with JOIN operations, filtering for courses with three…

Q: The HR department needs a report to display employee information as shown from the job_history…

A: SOLUTION- With using DATEDIFF - Below is the SQL query that you could use to generate the report:…

Q: Display employee information for all the employees in each state who were hired before the most…

A: Here have to determine about sql query for most recent hire person by given table diagram.

Q: 1. List the address, square footage, owner number, services ID, number of estimated hours, and…

A: List the address, square footage, owner number, service ID, number of estimated hours, and number of…

Q: Find the service ID and property ID for each service request whose estimated hours is greater than…

A: Hello student Greetings Hope you are doing great. Thank You!!!

Q: The State of New York certifies firefighters throughout the state and must keep track of all of…

A: Given: The State of New York certifies firefighters throughout the state and must keep track of all…

Q: Type Reduction in cell M1   The amount is 50% of sick days above 10, whenever sick days exceed 10.…

A: We need to find the formula using if else.

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: Write a Java program that creates and maintains a binary search tree (BST) whose nodes are student…

A: Introduction We must first understand BST in order to solve this code. A node-based binary tree data…

Q: 8. In the OrderItems table, display the minimum item_price with the alias shown. 2.49 1 rows…

A: Below is the complete solution with explanation in detail for the given question about writing query…

Q: For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name,…

A: Hi there, Please find your solution below, I hope you would find my solution useful and helpful.…

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: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

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

Q: With the following table:   PRODUCTS(PRODUCT_NUMBER, DESCRIPTION,PURCHASE_DATE,CATEGORY)   Write…

A: Given table is:PRODUCTS(PRODUCT_NUMBER, DESCRIPTION,PURCHASE_DATE,CATEGORY)Write the mySQL statement…

Q: Use SQL to write the following queries: a) Find the last names of students born after January 1,…

A: In this question we have to understand about the given SQL queries and suggest if these queries are…

Q: List the department name and its instructor’s average salary in which the instructors teach a course…

A: SQL implements WHERE clause with SELECT command in order to retrieve stored information from the…

Q: We want to select all employees from a table named EMPLOYEE for employees whose last name is not…

A: SELECT * FROM employee WHERE Last_Name <>  'Adam' ;

Q: Please help with the following What is a valid GROUP BY clause for the following SELECT list?…

A: Given:   Please help with the following What is a valid GROUP BY clause for the following SELECT…

Q: The State of New York certifies firefighters through- out the state and must keep track of all of…

A: Introduction: A relational database model provides a way of organizing related data and information…

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: USE NORTHWIND DATABASE Write a SELECT statement using the CASE function. The statement returns two…

A: sql select statement for above question is shown in step2

Q: For each different job_id group in the employee table, show the average salary and job_id for the…

A: SELECT Average_salary,              Job_id  FROM employees  WHERE EXISTS (SELECT *…

Q: 7. List all customers who were referred to the bookstore by another customer. List each customer’s…

A: The answer to the question is given below:

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: Queries are given below :

Q: 2) Create a SELECT statement that returns the count, average, max and min of the invoices submitted…

A: SQL: SQL is defined as Standard Query Language it is mainly used for the manipulation of the…

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

A: Solution :

Q: For each sale made on June 1, 2015, show the following information: CustomerID, Customer name…

A: Hey, since there are multiple questions posted, we will answer first question. If you want any…

Q: . Using the Henry Books database, list the book code and title of every book that has the type SFI…

A: In this question we have to write a query for using a Henry book database for the given queries…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: Display the current day of the week, hour, minutes, and seconds of the current date setting on the…

A: 5)SELECT TO_CHAR(CURRENT_DATE,'DAY,HH:MI:SS') FROM dual;           (Or)

Q: list the number of equipment with the same first three letters (the start code, e.g., CAM, DIV) in…

A: THE ans is an given below :

Q: Below are some rows of the PROVIDERS table for a factory:   PCODE NAME PHONE 10192 Hans, Inc.…

A: In this casе,  wе arе working with a "PROVIDERS" tablе for a factory,  and thе goal is to rеtriеvе…

Q: 5. In the OrderItems table, display a count of the number of products where item_price is greater…

A: Algorithm:From the OrderItems tableFrom the OrderItems tableWhere item_price is greater than or…

Q: Task 7: List the square footage, owner number, owner last name, and owner first name for each…

A: Given: Task 7: List the square footage, owner number, owner last name, and owner first name for each…

Q: For each product, show the product ID and the number of orders placed. Show the results in…

A: Introduction: SQL (Structured Query Language) is a database computer language designed primarily for…

Q: 3. Determine the amount of total profit generated by the book purchased on order 1002. Display the…

A: ANSWER:-

Q: You have the following table:   MANAGERS (MANAGER_ID, LAST_NAME, FIRST_NAME, DEPARTMENT)   Write…

A: Stored procedures in a relational database management system (RDBMS) are powerful tools for…

Q: In the Summary sheet, calculate average and median sales and commissions. Use the named ranges shown…

A: To calculate the average and median sales and commissions using the named ranges shown in cells…

Q: SQL code for: (1) Hint: A NULL in the hours column should be considered as zero hours. Find the…

A: SQL: SQL stands for Structured Query Language. It is easy to learn. It is a standard language for…