The following query reports the highest bonus amount of all employees by year and job code. Complete the missing values. SELECT Date.Year, _(A). MAX(__(B)__) FROM Date, Job, Date StartDate, Date EndDate, EmployeeFact WHERE Job.JO6ID = EmployeeFact.JobID AND StartDate.DateID = EmployeeFact.StartDateID AND EndDate.DateID = EmployeeFact.EndDateID AND (C). BETWEEN StartDate.Year AND EndDate.Year GROUP BY _(D)__

The following query reports the highest bonus amount of all employees by year and job code. Complete the missing values. SELECT Date.Year, _(A). MAX((B)) FROM Date, Job, Date StartDate, Date EndDate, EmployeeFact WHERE Job.JO6ID = EmployeeFact.JobID AND StartDate.DateID = EmployeeFact.StartDateID AND EndDate.DateID = EmployeeFact.EndDateID AND (C). BETWEEN StartDate.Year AND EndDate.Year GROUP BY _(D)__

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

Task 18: List the item ID, description, unit price, and category for each item that has a unit price greater than the unit price of every item in category CAT. Use the ALLoperator in your query. Task 20: Repeat Task 18 using the ANY operator. *Both are needed answered but ideally task 20 needs to be done, task 18 is here for task 20
Write a query that will display all movies with a return date of March 1, 2018, March 5, 2018, March 15, 2018, March 17, 2018 or March 25, 2018. Note: Do not use the OR operator for this query.
SQL List location name, owner first name, owner last name, state, unit number, bedrooms, baths, and condo fee. Only include condos from the Solmaris Ocean location.
Management is considering closing on Sundays and would like to have a feeling for the kinds of customers that come to the dealership on Sunday. Create a totals query that shows the count of encounters on the Sundays of July 2015—grouped by the credit description held by the customer of the encounter. The Sundays in July of 2015 are the 5th, 12th, 19th, and 26th. Your answer should have two columns (CreditDescription and encounter_count) and should be sorted alphabetically by credit description.
Write a query that uses INNER JOIN TO connect the EMPLOYEE, EMPPROJACT, PROJACT and PROJECT tables. Include the Project number , Department number, Project start and end date and AC STAFF WHERE They belong to department D11 , Salary is more than or equal to 65 percent of $15,000 AND Salary is less than or equal to 130 percent of $40,000
question 11 please use the picture below to answer the following question Write a SQL statement to change the value of the column Invoice_Date (new_invoice table) to today's date for Customer ID 10.
Create a new table, EMP_PROMOTION to store the employees information. You must use a subquery to create the new table. Make the salary column invisible. Display the structure of the table in SQL Developer. Also use a SELECT statement to display all records from the new table EMP_PROMOTION.
Q. Please write SQL codes to query data from member tables based on below criteria Please write a SELECT statement to display each member’sdata that member_id is an odd number. Please display the result in ascending order of the last_name. The result should be identical to below results: [Screenshot]
Use the code below to write a query to display the movie title, movie year, and movie genre for all movies CREATE TABLE MOVIE ( MOVIE_NUM NUMBER(8,0) PRIMARY KEY, MOVIE_TITLE VARCHAR2(75) NOT NULL, MOVIE_YEAR NUMBER(4,0) CHECK (MOVIE_YEAR > 1900), MOVIE_COST NUMBER(5,2), MOVIE_GENRE VARCHAR2(50), PRICE_CODE NUMBER(2,0) CONSTRAINT MOVIE_PRICE_CODE_FK REFERENCES PRICE ); INSERT INTO MOVIE VALUES (1234, 'The Cesar Family Christmas', 2011, 39.95, 'FAMILY', 2); INSERT INTO MOVIE VALUES (1235, 'Smokey Mountain Wildlife', 2008, 59.95, 'ACTION', 1); INSERT INTO MOVIE VALUES (1236, 'Richard Goodhope', 2012, 59.95, 'DRAMA', 2); INSERT INTO MOVIE VALUES (1237, 'Beatnik Fever', 2011, 29.95, 'COMEDY', 2); INSERT INTO MOVIE VALUES (1238, 'Constant Companion', 2012, 89.95, 'DRAMA', NULL); INSERT INTO MOVIE VALUES (1239, 'Where Hope Dies', 2002, 25.49, 'DRAMA', 3); INSERT INTO MOVIE VALUES (1245, 'Time to Burn', 2009, 45.49, 'ACTION', 1);
Management is considering closing on Sundays and would like to have a feeling for the kinds of customers that come to the dealership on Sunday. Create a totals query that shows the count of encounters on the Sundays of July 2015—grouped by the credit description held by the customer of the encounter. The Sundays in July of 2015 are the 5th, 12th, 19th, and 26th. Your answer should have two columns (CreditDescription and encounter_count) and should be sorted alphabetically by credit description. This is what Ive been working with and doesn't give me results, just error messages. SELECT R.CreditDescription, E.CustomerID FROM Encounter E JOIN Customer C ON E.CustomerID = C.CustomerID JOIN CreditRating R ON C.CreditID = R.CreditID WHERE E.EncDate = STR_TO_DATE('2015-07-05','2015-07-12','2015-07-19','2015-07-26'); ORDER BY creditrating.creditid, ASC; creditrating creditid creditdescription minfico maxfico comments customer customerid cfirstname clastname…
The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
Create a stored procedure called sp_shipping_date where the billing date is equal to the order date plus 15 days. The billing date will be an input parameter for the stored procedure. Display the order id, order date and shipped date from the Orders table, the company name from the Customers table, and the company name from the Shippers table. Use the following query to test your stored procedure to produce the result set listed below. EXEC sp_shipping_date 'yyyy-mm-dd' ----------- the answer I wrote is below, but is incorrect as no result from the query. Please assist to fix it. thanks. --------------------- create procedure sp_shipping_date (@billing_date datetime) as select Orders.OrderID, CustomerName = Customers.CompanyName, ShipperName = Shippers.CompanyName, Orders.OrderDate, Orders.ShippedDate from Orders inner join Customers on Orders.OrderID=Customers.CustomerID inner join Shippers on Orders.ShipperID=Shippers.ShipperID where @billing_date =DATEADD(day,15,OrderDate) go