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: 12. Report the names of the professors who supervise more than one student. 13.  Report the names…

A: In order to find professors who supervise more than one student, we will need a COUNT() function on…

Q: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

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 list showing only the EmployeeID, Sales, and Projected Sales sorted from highest to lowest…

A: The query selects the specified columns from the EmployeeSales table and orders the result set based…

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: Cust_id (NOT NULL) Txn_date (Not NULL) Txn_type (NOT NULL) Txn_amount (NOT NULL) 1 2020-01-21…

A: The CREATE TABLE statement is used to create a new table. Syntax: CREATE TABLE table_name (column1…

Q: List the invoice number and invoice date for each invoice created for the customer James Gonzalez

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

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: We need to write a SQL query that prints the table that has columns are- FirstName, LastName,…

Q: Based on the ERD below, write the SQL statement to display the average hourly job charge for a job.

A: Query to display the average hourly job charge for a job. To get average hourly job charge for all…

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: Who has rented movies in Japanese language? Return only the first five distinct results in…

A: The INNER JOIN keyword chooses records from both tables whose values match. The SELECT clause just…

Q: Show all female’s first names and their salary.  Show the branchno that has a supervisor whose…

A: Relational database is a type of database which stores and provides the access to data which are…

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: View 3 Seneca Courses Inc. Employee Forms All employee information for SCI is maintained on file…

A: Actually, the answer has given below:

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: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition.  student…

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

A: Hello Student. Warm welcome from my side. Hope you are doing great. Here's your answer. Hope you…

Q: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

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: 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: 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: 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: Check the following statement: select sysdate Today, (select count (*) from departments)…

A: Solution :

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

A: Given: Structure of a table employee is given having attributes First_Name, Last_Name, SSN_Number.…

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: Task 15: List the invoice number and invoice date for each invoice that either was created for James…

A: The solution is given below for the above given question: