Based on the ERD below, display the assignment number, employee number and assigned hours for either assign job 501 or 502 with assigned hours more than 3.

Q: If a GROUP BY clause is included in a SQL query, the characteristics that may be sought in the…

A: Introduction: The Aggregate BY clause in SQL is used to group the results of a SELECT operation on a…

Q: Write a SQL query that displays the number of customers who born on the 16th day of a month .  Write…

A: 1. select count(customerID) from Customers where to_char(custDOB,'DD') = 16; 2. select customerID…

Q: Get a list of visit reasons of which the average cost is greater than 2000 but less than 2050. •…

A: The SQL Query to extract the given output is: SELECT VisitReason, AVG(Cost) AS “avgcost” FROM visit…

Q: Q1. Please write SQL codes to query data from member tables based on below criteria  Please write a…

A: In step 2, you will get error-free SQL query.

Q: Employee_id          Name          Salary 1001                         Annie           6000 1009…

A: SELECT * FROM employee WHERE employee_id>1009   employee_id will be 1018 And output will be…

Q: For each employee, show their full name and the region name of their department

A: Assuming Sql query for given statement is asked,  considering table employee, with attributes…

Q: Show all name and phone numbers of students and the type of donation they received including any…

A: Show all name and phone numbers of students and the type of donation they received including any…

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: SQL 1.Show the first name of employees and their related department name. 2.For each employee,…

A: Given: SQL 1.Show the first name of employees and their related department name. 2.For each…

Q: Every guide receives their first review 6 months after their hire date. List the guide’s last name,…

A: SQL query to display all the list of the guide’s last name, first name, hire date, and his/her first…

Q: See the following table CREATE TABLE product ( product_id NUMBER(3), product_name VARCHAR(30) NOT…

A:

Q: Question 1 Display employee ID, first name, last name, and corresponding department names. Question…

A: Query Approach:   1- As mentioned in the assignment created the database name as bank inside the…

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

A: SQL answers to the above first 3 questions are in step2 as per our guidelines we are supposed to…

Q: Write the SQL code that will list only the distinct project numbers in the ASSIGNMENT table, sorted…

A: DISTINCT is the keyword used to get the distinct items from the Table related to the column used…

Q: Using the data in the ASSIGNMENT table, write the SQL code that will yield the total number of hours…

A: Please check the step 2 for required sql code

Q: Using SQL Show the distinct location_id for all the locations where the company has departments

A: SQL  SQL stands for Structured Query Language, and it is a programming language used to store,…

Q: Using the data in the ASSIGNMENT table, write the SQL code that will yield the total number of hours…

A: SQL code The SQL code for getting employee number, employee last name, sum of assigned hours and…

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: Answer the query using SQL. For each department that controls more than 3 projects, retrieve the…

A: Introduction of DBMS: A database is a collection of data that are used to produce useful information…

Q: For every completed or 'open service request for janitorial work', list the condo id, description,…

A: The querry has given

Q: Using the data in the ASSIGNMENT table, write the SQL code that will yield the total number of hours…

A: Here  Table Name is ASSIGNMENT and corresponding attributes need to find are EMP_NUM , EMP_LNAME,…

Q: Find all manager names and all the employees each manager supervises

A: The given sample table has EMPNO as the primary key and MGR a foreign key which is refereing to same…

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: Delete all the employees in the department that has less than 3 employees using sql

A: Explanation: The deletion is based on “DEPTNO” in “EMPLOYEE” table. “delete” command is used to…

Q: SELECT DISTINCT empname FROM employee; In what order are the empnames displayed?

A: We are given a SQL query and we are going to find out the output of it.  We are using DISTINCT…

Q: . Please write SQL codes to query data from member tables based on below criteria  Please write a…

A: A number is odd number if its remainder when divided by 2 is not equal to 0

Q: Show the first name and the last name of students who are in Active status.

A: Sql query for selecting the irst and last name of the student from given table ‘STUDENT’ who is in…

Q: write an sql query that displays the parking space number location as well as the name of the staff…

A: Given that write an sql query that displays the parking space number location as well as the name of…

Q: Write the SQL code to find the average Assign_Charge by Job_code  from the Assignment table.  Write…

A: 1) Write the SQL code to find the average Assign_Charge by Job_code  from the Assignment table.…

Q: 1. List the Customer Id, Last Name for all customers, sorted by Last Name, ID. Table "Customer Id"…

A: As per our company guidelines we are supposed to answer only first 3 sub-parts. Kindly repost other…

Q: amed company with these columns: Company_id varchar(255) Company_na

A: Create a table named company with these columns: Company_id varchar(255) Company_name varchar(255)…

Q: Display details of jobs where the minimum salary is greater than 10000. using sql plus

A: SQL Query: Assume a database JOBS which has Columns JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY. Now,…

Q: 5: List the names of all salespeople and a count of the number of members they work with. (use uter…

A: Customer_id Name City Grade Saled_ID 1 Ricky Sydney 30 1001 2 Roy Delhi 20 1002 3 Bob London…

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: List the index number, and course number for all classes taught by Dr. Smith during the Fall 02…

A: The query provided is done using SQL and considering all the data is present in a single table as…

Q: What is the average cost of the most popular visit reason? Name the average cost column as avgcost.…

A: Objective: A database is provided including two relations Patient and Visit. The most popular visit…

Q: In the SQL Oracle Application List all employees who have not changed jobs even once. (Such…

A: DISTINCT : The statement SELECT DISTINCT will return the unique/distinct values from the table, this…

Q: Delete the employee who has the longest employment in the company using sql

A: can be done by sorting the table and then deleting the oldest date row. please see the SQL script in…

Q: nter Employee Id : 101 Enter Enployee Id : nter Employee Name : John Hathew Enter Employee Nane ter…

A: I have written code below:

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: Display a list of all book titles and the percentage of markup for each book. The percentage of…

A: ROUND function The ROUND function is defined as a numerical function in Oracle or SQL to round the…

Q: Using SQL find the number of employees from the table:

A: We just need to count all the rows in the given table that will result in the number of employess.

Q: Show a list of employee id, names, department, years and job of any employee in the staff table who…

A: First you have to make a table called Employee after this you just have to enter random values to…

Q: Display job Title, the difference between minimum and maximum salaries for jobs with max salary in…

A: Answer: SELECT JOB_TITLE, MAX_SALARY-MIN_SALARY DIFFERENCE FROM JOBS WHERE MAX_SALARY BETWEEN 10000…

Q: write the sql code required to list the employee number, last name, first name, and middle initial…

A: The structured Query Language (SQL) code to list the employee number, last name, first name, and…

Q: Display last_name from students table who obtained below 75 algebra_grade or trigonometry_grade.

A: Since the question did not provide a  table and its columns, a sample table Students created with…

Q: Display details of employee with ID 150 or 160. using sql

A: To find the details of the employee having ID 150 or 160.   Note:  The detail of the table is given…

Q: Use Employees table to display the department id and highest salary with the column name "Highest…

A: The Answer is

Basic SQL Queries

Structured Query Language is the full form of SQL. It is a high-level language used to communicate with a relational database. It is used for creating, storing and accessing contents of a relational database. SQL is used to write the queries which are executed using database engines like Oracle, SQL Server and so forth.