1. Write a query to display the employee name and hiredate for all employees in the same department as Blake. Exclude Blake. ENAME HIREDATE ALLEN WARD 20-FEB-81 22-FEB-81 MARTIN 28-SEP-81 TURNER DAMES 08-SEP-81 03-DEC-81 2. Create a query to display the employee number and name for all employees who earn more than the average salary. Sort the results in descending order of salary. 7839 KING 7902 FORD 7788 SCOTT 7566 JONES 7698 BLAKE 7782 CLARK

Q: Write a query to show all employee name, present salary and 30% incremented salary of those…

A: The given problem is related to database query language where the CREATE table statement is given…

Q: Write a query to display the employee name and hire date for all employees in the same department as…

A: Task : Write the SQL query to find the data of all employee for the department = 'Blake'.

Q: a. Find all movies with a cost less than or equal to the average moVies cost b. Write a query to…

A: Select Query:          It will retrieve data from the table.         select * from table name;…

Q: Write a query to display all vendors sorted by vendor name. Write a query to display the product id,…

A: As per our company guidelines we are not supposed to answer more than 3 subparts of question and…

Q: d. write a query to retrieve the name of graduate student and student advisor name of all graduate…

A: The query works for both ms sql server and mysql.

Q: 5. Write a query to get the total salaries payable to employees. 6. Write a query to get the…

A: Sorry, we are supposed to answer only three subparts of question ad kindly resubmit the remaining…

Q: 1. Write a query that displays the employee number and last name of all employees who work in a…

A: Here is the answer:-

Q: 2. Find the names and degrees of graduate students whose degree is better than some graduate…

A: The answer given as below:

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

A: Query:   SELECT emp.emp_num, emp_lname, emp_fname, emp_email, totalFROM lgemployee AS emp INNER JOIN…

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

A: Actually, given information: The Binder Prime Company wants to recognize the employee who sold the…

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

A: Lets see the solutioin

Q: Problem 1O Write a query to count the number of customers with a balance of more than $500.

A: Solution:   Given,     SQL Query:   SELECT count(customer_id) FROM CustomerWHERE balance > 500;…

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 retrieve the name of graduate student and student advisor name of all graduate…

A: Query to find or retrieve the name of graduate student and student advisor name of all graduate…

Q: Write a query to display the author ID, author last name, book title, checkout date, and patron last…

A: SYNTAX The syntax for the query is as follows. SELECT column1, column2 FROM table1 JOIN table2 ON…

Q: Write a query to display the customer code, first name, and last name of all customers who have had…

A: “SELECT” statement: It is used to retrieve information from the table or database. The syntax for…

Q: Write a query to display job ID, total salary and employee name whose job_id contains “REP” and…

A: We have 2 tables. One is emp other is dept. Let take high sal be the total salary (as the table are…

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

A: Information Provided: According to the problem statement provided we should upgrade the SQL query to…

Q: Write a query to print all employees name, job title, salary and department name. ii. Write a query…

A: i. select e.ename, e.job, e.sal, d.dname from emp e, dept d where d.deptno=e.deptno; ii. select…

Q: Write a query to display the patron ID, patron full name, and patron type for each patron sorted by…

A: ORDER BY is the command used to sort the result to display

Q: 1: Write query to create canteen_table. Put check on category values as only “junk” and “Not junk”.…

A: The given problem is related to database SQL queries where the requirement is to create the table…

Q: Write a query to display the resort Id, the total count guests stayed as "Total Guest' in each…

A: Given in the above question we have to create a SQL code to display the resort Id, the total  count…

Q: 1) Write a query to print all clerks and salesmen names and salaries along with their departments…

A: Q: Write a query to print all clerks and salesmen names and salaries along with their departments…

Q: Display the name concatenated with the job ID, separated by a comma and space, and name the column…

A: /*Create New table */ Create table Emp(EMP_NO int Primary key,EMP_NAME varchar(30),EMP_GRADE…

Q: Write a query to display the patron ID, full name (first and last), and patron type for all patrons.…

A: - select clause is used to retrieve data from given table and returns data in the form of table. -…

Q: Write a query to display the patron ID, full name (first and last), and patron type for all patrons.…

A: In SQL, to sort the query output "order by" clause is used. In SQL, by default sorting on a…

Q: Write a query to display all vendors sorted by vendor name.   Write a query to display the product…

A: Database management queries are

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

A: Introduction: Our task is to write the query to take the Student ID and First Name for the table…

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

A: Task: Our task is to write the query to take the Student ID and First Name for the table which is…

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

A: Task: Our task is to write the query to take the Student ID and First Name for the table which is…

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

A: Task: Our task is to write the query to take the Student ID and First Name for the table which is…

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 statement we have to develop SQL query to display the guest names who are…

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

A: Query to generate a report indicating the total number of sick leave days for each employee. Given:…

Q: Write a query to display list of students name who all are from IT department. Sort the result based…

A:

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 statement we have to develop SQL query to display the guest names who are…

Q: Write a query to fetch details of employees whose EmpLname ends with an alphabet ‘B’ and contains…

A: GIVEN: Write a query to fetch details of employees whose EmpLname ends with an alphabet ‘B’ and…

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

A: Note : Here I have created a Doctors table as example to solve the problem. Algorithm :  Step :…

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

A: According to the given question we are required to display student's Id and First Name whose from…

Q: Write a query to display the mobile model name which has made the maximum sales. Give an alias for…

A: According to the given question here we have to develop a SQL code that display the mobile  model…

Q: Write a query to display list of students name who all are from IT department. Sort the result based…

A: According to the given problem statement we are required to find out list of students name who all…

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

A: Select statement is used to display data from database. We need to display studId and firstname of…

Q: Write a Query to get the First Name, Last Name and Salary of the employee who is paid the lowest…

A: In SQL, the subquery is used to return data that will be used in the main query as a condition to…

Q: Write a query to list the details of all authors born in the decade of the 1980s.

A: Where clause: Only displaying information for all authors born in the decade of the  1980s. You can…

Q: Create a query to display all donors that live in City1, City2 or City3. Use the IN clause.

A: here In question ask query about IN clause Query: display all donors that live in City1, City2 or…

Q: Write a query to fetch employee names and salary records. Display the employee details even if the…

A: Given: Write a query to fetch employee names and salary records. Display the employee details even…

Q: Create a query for displaying maximum salary earned by employee working in IT department. Provide…

A: Lets see the solution.

Q: Write a query to display the customer code, first name, last name of all customers who made more…

A: Select: The SELECT statement is used to select data from a database. SELECT Syntax SELECT…

Q: Write a query to display the author ID and the number of books written by that author. Sort the…

A: Explanation: The below query displays “AU_ID” and total book numbers from “WRITES” tables using…

Q: Write a query to display student Id who registered for the course 1001, 1005. If they registered for…

A: To display student who selected both subjects we have to use distinct keyword  To display by sorting…

Q: Write a query to display student Id who registered for the course 1001, 1005. If they registered for…

A: Required: We have to write a sql query to display student Id who registered for the course 1001,…