write the query that displays the name and vacation time for each employee
Homework Answers
As table information is not present I have assumed below table ,if table structure is different please let me know i will modify the query accordingly.
EMPLOYEE(NAME,VACCATIONTIME,VACCATIONPLACE) and NAME is unique.
Query to find name,vaccation time for each employee:
SELECT NAME,VACCATIONTIME FROM EMPLOYEE ORDER BY NAME;
Add Answer to:
write the query that displays the name and vacation time for each
employee
I need to write a SQL query that displays the first name and last name of...
I need to write a SQL query that displays the first name and last name of each author along with the number of books he or she has written. Capitalize the first and last names. AUTHOR table: AUTHORID, LNAME, FNAME BOOKAUTHOR table: ISBN, AUTHORID BOOKS table: ISBN, TITLE, PUBDATE, PUBID, COST, RETAIL, DISCOUNT, CATEGORY
SQL query: Write an SQL query that will output the last name, employee id, hire date and department from the employee table. Pick only those employees whose department ID is specified in the employee...
SQL query: Write an SQL query that will output the last name, employee id, hire date and department from the employee table. Pick only those employees whose department ID is specified in the employee table. If the employee id is 777, name is ABC and hire date is 01-JAN-2016, the output should look as follows - 'Stephen (Employee ID - 777) was hired on the 1st of January, 2016 – Department: 90'. Note - The date should not have preceding...
Problem 33, chapter 7 from Database Systems 13th edition by Coronel Write a query to display...
Problem 33, chapter 7 from Database Systems 13th edition by Coronel Write a query to display the employee number, last name, email address, title, and department name of each employee whose job title ends in the word “ASSOCIATE.” Sort the output by department name and employee title Problem 36, chapter 7 from Database Systems 13th edition by Coronel Write a query to display the number of products within each base and type combination, sorted by base and then by type...
Relational algebra (RA) For the database schema shown below, write RA query for each of the...
Relational algebra (RA) For the database schema shown below, write RA query for each of the following. (State any reasonable assumptions only if necessary) employee (person_name, street, city) works(person_name, company_name, salary) company (company_name, city) Questions: Find person names, streets and cities of employees who work for two different companies. For each company, find person name, salary, street and city for the highest paid employee of that company. For each company, find total number of employees and total number of cities...
Write a SQL query that shows the price of each order made by customers whose last name starts wit...
Write a SQL query that shows the price of each
order made by customers whose last name starts with the
letter M. Display the order number, the last name on the order, and
the price of the order (Order Price). Show the results with the
highest order price first.
Write a SQL query that determines the most
expensive item purchased in each order (Item Price). Display the
order number, the date of the order, the last name of the customer...
Write Java code with JDBC (as discussed in class) to perform the following tasks: EMPLOYEE(Name, Ssn,...
Write Java code with JDBC (as discussed in class) to perform the following tasks: EMPLOYEE(Name, Ssn, Address, DeptNo, Age, Salary) DEPARTMENT(Dname, Dnumber, Budget, Mgr_ssn) Establish a logical session with a database you have created for the two relations Use JDBC to submit an SQL query and print the name of each employee with a salary greater than 100,000
1. Write a query to list the first name and last name of those pilots who...
1. Write a query to list the first name and last name of those pilots who were hired after January 1, 2010. Sort your result by the ascending order of last name. Within matching last names, order by first name. 2. Write a query to list flight number, pilot number, pilot last name for all flights whose destinations are using the IN keyword. 3. Write a query to list the names and telephone numbers of the passengers who have reservations...
Course: Fundamentals of Databases Write a Query for the Following Table. Table Name: Student Stu_ID Name...
Course: Fundamentals of Databases Write a Query for the Following Table. Table Name: Student Stu_ID Name Age Address Phone 1452364 Alla 22 Riyadh 7772223310 1452365 Ahamed 25 Jeddah 7772223311 a) Write a Query for Create Table: b) Write a Query for insert filed in above Given Table. c) Write a Query for Replace Age = 25 Replace by 26 the above given Table. d) Write a Query for Remove Student ID =1452364 one Row above given Table. e) Drop Student...
Apple inc. allows each employee to earn 15 fully paid vacation days each year. unused vacation...
Apple inc. allows each employee to earn 15 fully paid vacation days each year. unused vacation time can be carried over to next year, if no taken during the next year then its lost. vacation pay is accrued at the pay rate in effect during the year it is earned. by the end of 20X8, all but 3 of 20 employees had taken their earned vacation time, these 3 employees carried over to 20X9 a total of 20 vacation days....
Write SQL Queries for the following Select the employee name and no of departments each employee...
Write SQL Queries for the following Select the employee name and no of departments each employee works for Select the employee names with salary greater than average salary of all employees Select the department names with no manager assigned yet. Select the employee names who work for more than 1 department. Select the employee names and their manager names (keep in mind, one employee works for multiple departments so they will have multiple managers). Select the name and salary of...
Write a SQL query that shows the price of each
order made by customers whose last name starts with the
letter M. Display the order number, the last name on the order, and
the price of the order (Order Price). Show the results with the
highest order price first.
Write a SQL query that determines the most
expensive item purchased in each order (Item Price). Display the
order number, the date of the order, the last name of the customer...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago