Write a query that will indicate which employee has been booked off for the most number of days by doctor ‘D0001’. Display the employee name and surname, doctor name, and the number of days.

Q: The HR department needs the following reports: 4. Find the highest, lowest, sum, and average salary…

A: Below are the required SQL queries:

Q: Write a query to list the first name and last name of all authors. Concatenate the first and last…

A: The SQL query is: SELECT CONCAT(CONCAT(firstname,' '),lastname) AS FullName FROM author;…

Q: Code a query that will make use of SQL Server intrinsic functions and reference the Instructors…

A: SELECT (FirstName + ' '+LastName)AS Instructor_Name,YEAR(HireDate)AS…

Q: The Binder Prime Company wants to recognize the employee who sold the most of its products during a…

A: We need to provide a query to display the employee number, employee first name, employee last name,…

Q: Write a query to display the employee number, first name, last name, and largest salary amount for…

A: Actually, database is a used to stores the data.

Q: ELECT Rating FROM Professor P1 VHERE 5>= (SELECT COUNT(*) FROM Professor P2 WHERE P1.Rating…

A: Introduction :

Q: Now write a query which make use of equijoin to display the output as follows: Output Amani CS306…

A: I have provided a solution in step2.

Q: Write a SQL query to count the number of orders that have a purchase amount greater than 1000

A: SUMMARY: - hence we discussed all the points

Q: A.Write a query to show for each course how many sections are there? You need to display course…

A: According to Bartleby's rules, I will answer only the first question. The SQL code is given below

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: The query that displays birth date of employee whose ssn = 123456789 in format 'Saturday…

A: to_char() is used to format output in specified format  Day Month/dd/Year is the format to get…

Q: Q2/ The difference between the results of executing the following two SQL queries: Select…

A:

Q: write sample sql quiries for these Write a query to display employee number, first name, job id…

A: Please refer below for your reference: Queries are: 1. SELECT employee number, first name, job id…

Q: Use sub queries to answer the following Q1) write a query to display the employees first name and…

A: Note:- since table name is not we had given queries according to question given Syntax:   select…

Q: Write a query to display the number of people with the same job. JOB ID COUNT() AC_ACCOUNT AC_MGR AD…

A: Here, we have to group the employees based on the job_id and then count the number of employees in…

Q: First create a query for cursor..  cursor  cur1   as SELECT e.first_name, e.last_name, e.salary,…

A: CREATE TABLE EMPLOYEE( EMPLOYEE_FNAME VARCHAR(10), EMPLOYEE_LNAME VARCHAR(10), JOB_ID VARCHAR(5),…

Q: 6. Write the SQL code to validate the ASSIGN_CHARGE values in the ASSIGNMENT table. Your query…

A: The first query should validate the the ASSIGN_CHARGE values in the ASSIGNMENT table. ASSIGN_CHARGE…

Q: Write a query to display the guest names who are from Ooty. For instance, the guest name "geeta…

A: Question Breakdown: According to the problem statement provided we should upgrade the SQL query to…

Q: Write an sql query to show country code, country name of those employees whose country name…

A: Please refer below for your reference: Queries: 1.SELECT country code, country name FROM employees…

Q: *Query in SQL required* Write a query to display student's Id and First Name whose from Coimbatore…

A: As per the given question we have to develop a SQL query to display student's Id and First Name…

Q: Write a query to display the patron ID, first and last name of all patrons that have never checked…

A: Answer 1:- Query to copy : select PAT_ID, PAT_FNAME, PAT_LNAME from PATRON where PAT_ID not in…

Q: SELECT name FROM instructor WHERE salary = 90000; This query can be replaced by which of the…

A: In the given sql query, the "instructor" table is used. But in option b and option c, employee table…

Q: Write a sql query to show first name, job number and department number of those employees whose…

A: The queries for both questions given below

Q: SQL SELECT name, yrgoal, contamt 2 FROM donor, donation 3 WHERE donor.idno = donation.idno AND…

A: Given are two tables, Donor table and Donation table. Donor table has attributes idno, name, stadr,…

Q: Write a query to display the author ID, first and last name for all authors that have never written…

A: We indeed to provide SQL query to display the author ID, first and last name for all authors that…

Q: Write a query to display PUBDATE is after 21st January

A: Note: In this question, No table is given. We are creating a sample table to perform the query on…

Q: Find the output of the following query: SELECT INITCAP (COURSE NAME) FROM STUDENT WHERE…

A: Answer : -   option A) Math For It, Maths For It

Q: Q1) Write a query that count the employees in each department? Q2) Write a query that retrieve all…

A:

Q: Q1 Show all data from employee table where name should be in ascending and salary in descending…

A: Question 1 Ans : SELECT * FROM employee e  ORDER BY e.name ASC, e.salary DESC; Question 2 Ans :…

Q: Write a query to display the brand ID, brand name, and average price of products of each brand. Sort…

A: Database management language: The database management system is a collection of inter-related data…

Q: Given the following table TABLE EMPLOYEE Column Null? Туре EMP_ID NOT NULL NUMBER EMP_LNAME…

A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…

Q: Write a query to display the first name, last name, street, city, state, and zip code of any…

A: Actually, SQL is a language to operate databases in searching and filtering the data according to…

Q: Write a query to display the author ID, first and last name for all authors that have never written…

A: From a database, required information can be retrieved by the query language. The queries must be in…

Q: Write a query to display the patron ID, book number, and days kept for each checkout. “Days Kept” is…

A: below are the two commands that you can try: 1.   Select PATRON.PAT_ID, BOOK.BOOK_NUM,…

Q: Write a query to display student's Id and First Name whose from Coimbatore or Chennai and born on…

A: SELECT statements is used to select data from database We need to display StudId, FirstName of…

Q: 19. Write a query to generate the total number of invoices, the invoice total for all of the…

A: Built-in functions: Structured Query Language (SQL) has some built-in functions and they are:…

Q: Find the output of the query statement based on the table given below. SELECT TO CHAR (Hire_date,…

A: fmDay will week ddth Mon displays month along with suffix for data YYYY displays year in 4 numbered…

Q: 1. Write a query to display the employee name and hiredate for all employees in the same department…

A: According to the Question below the Query:

Q: The query that will return the employee's ID and his full name is

A: The correct option is A

Q: I need help building a query that will return the following: - Average number of borrows by age…

A: Introduction: A DBMS stands for a database management system is essentially a computerized…

Q: Query 3: Write a parameter query to display the names of all prospects each member tried to recruit…

A: Here have to determine query for given problem.

Q: Q.2.3 Write a query that will indicate which employee has been booked off for the most number of…

A: Need to write query which displays employee who has been booked off for the most number of days by…

Q: Write a query to display the guest names who are from Ooty. For instance, the guest name "geeta…

A: As per the given problem we have to develop a SQL query to display the guest names who are from…

Q: 3. Run a query that gives the average grade on the final exam for male students and for female…

A: Since we need two groups of data i.e male and female, we must use group by clause and perform…

Q: Write a query to generate a report indicating the total number of sick leave days for each employee.…

A: As you have asked multiple questions, so we will solve first question for you. If you want any…

Q: I have the following problem for which I wrote teh code, but I am missing to round the last column…

A: Solution: Following is the query that retrieves  assignment number, employee number, project number,…

Q: 8- Write a query to generate the total number of invoices, the invoice total for all of the…

A: Objective: A query should be written to display the total number of invoices, the invoice total for…

Q: Write a query to display the book number, title, and number of times each book has been checked out.…

A: SELECT CHECKOUT.Book_Num, Book_Title, COUNT(*) 'Times Checked Out' FROM BOOK LEFT JOIN CHECKOUT ON…

Q: Write a query that returns all customers listed in the orders table who placed orders on the most…

A: The answer is given below.

Q: create a query for cursor..   cursor  cur1   as SELECT e.first_name, e.last_name, e.salary,…

A: SQL: "SELECT e.first_name, e.last_name, e.salary, e.job_id, j.min_salary, j.max_salary FROM…