Refer to the database Er diagram:-DEPARTMENTSdepartment_iddepartment_namemanager_idlocation_idLOCATIONSHRlocation_idstreet_addresspostal_codecitystate_provincecountry_idJOB_HISTORYemployee_idstart_dateΕMPLOYESend_datejob_iddepartment_idemployee_idfirst_namelast_nameemailCOUNTRIEScountry_idcountry_nameregion_idJOBSjob_idjob_titlemin_salarymax_salaryphone_numberhire_datejob_idsalarycommission_pctmanager_iddepartment_idREGIONSregion_idregion_name 1. Write a query that displays the employee number and last name ofall employees who work in a department with any employee whoselast name contains a "s". Use subquery2. The HR department needs a report that displays the last name,department number, and job ID of all employees whose working indepartment 90 and 100 and their department located in location ID1700.Use subquery

1. Write a query that displays the employee number and last name of all employees who work in a department with any employee whose last name contains a "s". Use subquery 2. The HR department needs a report that displays the last name, department number, and job ID of all employees whose working in department 90 and 100 and their department located in location ID 1700.Use subquery

1. Write a query that displays the employee number and last name of all employees who work in a department with any employee whose last name contains a "s". Use subquery 2. The HR department needs a report that displays the last name, department number, and job ID of all employees whose working in department 90 and 100 and their department located in location ID 1700.Use subquery

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Write a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 99675, 53845, and 44035. Sort the output by employee number and salary “from” date.
Write a query to list the book title, checkout date, checkout due date and checkout in date for each book.
Write a query to display the book title, price and publisher name for all books.
Q5: From the Customer table given below write SQL queries for the following question?  Write a query to display the record of the last name and city with unique state? Write a query to display the record of the distinct cities of the customers? Write a query to display the records of customers' address whose names contain letter “a”?
What are the most notable differences between abstract classes and interfaces?
ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear
Write a query to find the name of employees that begin with alphabet 'A'
Question 13 Write a query to display the last name, job of all employees whose last names starts with the letter "M".
database HR Write a query to display the last name, job, department number, and department name for all employees who work in Toronto.
4) Display the firstname, lastname of the employees and the customerID that the employee served. Arrange the results by the last name. 5) Write a query to the Name of the Product and the corresponding name of the supplier of that Product for all the products that start with a “P”. 6) Write a SQL query to output the product name and the quantity of the Orders of that product for those orders with more than 70 quantity. (hint: don’t have to use GROUP BY) I need help figuring out the SQL quereys for the questions above using table joining method
If a subquery is used in the FROM clause of a query, how are the subquery’s results referenced in other clauses of the query?
Task 3: The InstantRide Finance team wants to collect the price and discount information with the driver names for each travel in the system. You need to return the TRAVEL_ID, DRIVER_FIRST_NAME, DRIVER_LAST_NAME, TRAVEL_PRICE, and TRAVEL_DISCOUNT information from the TRAVELS and DRIVERS tables combined over DRIVER_ID field with the ON keyword. Task: Calculate each user's price and discount information. (SQL Database Test)