Refer to the dimension tables and EmployeeFact table below.JobDateLocationEmployeeFact•JobID•DatelD•LocationID• ( OEmployeelDTitleFullDateStreetAddressoJobIDJobCodeDayNumberCityPostalCodeOLocationIDLevelCodeMonthNumberoHireDatelDOBirthDatelD )SalaryAmountBonusAmountMonthNameStateYearCountryCodeEducationYearsPerformanceRatingThe following query reports the employee with the highest salary amount per postal codefor employees with level code 8. Complete the missing values.SELECT CountryCode, EmployeeID, MAX(__(A)_FROM(B).Location, JobWHERE EmployeeFact.LocationID = Location.LocationIDAND EmployeeFact.JobID =(C).AND= 8GROUP(A) Ex: Identifier(B)(C)

The following query reports the employee with the highest salary amount per postal code for employees with level code 8. Complete the missing values. SELECT CountryCode, EmployeeID, MAX(. (A). FROM _(B)_ L, Location, Job WHERE EmployeeFact.LocationID = Location.LocationID %3D AND EmployeeFact.JobID = (C). _(D). _(E). AND = 8 GROUP _(F).

The following query reports the employee with the highest salary amount per postal code for employees with level code 8. Complete the missing values. SELECT CountryCode, EmployeeID, MAX(. (A). FROM _(B)_ L, Location, Job WHERE EmployeeFact.LocationID = Location.LocationID %3D AND EmployeeFact.JobID = (C). _(D). _(E). AND = 8 GROUP _(F).

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

Related questions

Q: The query should list all employees whose Position begins with the word greenhouse and whose weekly…

A: These question answer is as follows,

Q: The team wants to track potential list of users who may have forgotten their items on the cars.…

A: SELECT U.USER_FIRST_NAME, U.USER_LAST_NAME, T.TRAVEL_START_TIME, T.TRAVEL_END_TIME FROM USERS U…

Q: The HR department needs a report to display employee information as shown from the job_history…

A: SOLUTION- With using DATEDIFF - Below is the SQL query that you could use to generate the report:…

Q: Your company needs to contact the 1st author of each textbook and to discuss reprint options. Pull…

A: Microsoft AccessMicrosoft Access is a relational database management system that allows you to…

Q: using the code belowe write a query to display the movie genre and average price rental fee for…

A: In the database analysis, understanding the distribution of movie costs across genres is a crucial…

Q: please use the picture below to answer the following question Display employee number, employee…

A: SELECT EmployeeID, Emp_LName, HireDate FROM Employee e JOIN Position pWHERE e.Emp_LName like '%e%'…

Q: using the code write a query to display the movie number, movie title, and price code for all movies…

A: Algorithm:Define a table named PRICE with columns PRICE_CODE, PRICE_DESCRIPTION, PRICE_RENTFEE, and…

Q: Display customer number, customer name, and location for customers whose Customer_name starts with…

A: The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. ORDER BY…

Q: SELECT name FROM instructor WHERE name LIKE % dar_ Which of the instructor names will NOT be…

A: The names “Alimdarr” and “Alimdar” will NOT be included in the result of given query. Hence the…

Q: Which line of the SELECT statement is used to restrict groups displayed in the query results?…

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

Q: Write query to find the balance characteristics for all customers, including the total of the…

A: Find the balance characteristics of all customers including the total of the outstanding balances.…

Q: Create a query that SELECT all of the EMPLOYEES from the EMPLOYEE TABLE that are Mangers. Include…

A: Self Join: A self join occurs when a table is linked to itself (also known as Unary…

Q: Management is considering closing on Sundays and would like to have a feeling for the kinds of…

A: The SQL query is given below with output screenshot and explanation Also a table with demo data has…

Q: Orders Table: OrderID,CustomerID, Order Date, TotalAmount Customers Table: CustomerID, CustomerName.…

A: In this question we have to create a query to retrieve the customer name and order date for each…

Q: Create a query based on tblReservations that displays the guests that have reservations for all…

A: Structured Query Language, abbreviated as SQL, which usually refers to the one it is a…

Q: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

Q: Please help with the following What is a valid GROUP BY clause for the following SELECT list?…

A: Given: Please help with the following What is a valid GROUP BY clause for the following SELECT…

Q: what is wrong with this query: Select Title,count(Rental_ID) as…

A: The query seems to be missing a join condition to link the Rental table with the Film and Inventory…

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: Management is considering closing on Sundays and would like to have a feeling for the kinds of…

A: Data analysis is an essential tool for management decision-making, especially in today's data-driven…

Q: Animal animal_id name adopter_id Adopter adopter_id name Given the above data for an adoption…

A: Cross join : Each row from the first table is combined with each row from the second table using a…

Q: Which one of the following attribute (set) should be candidate key? ( ) Student ID number, First…

A: In the context of database design, selecting the appropriate candidate key is crucial to ensure data…

Q: Create a query for displaying minimum salary in column alias “Minimum Salary” along with job_id…

A: Format of query :- SELECT colounname , MIN( coloumname) AS aliasname FROM tablename; According…

Q: Task 18: List the item ID, description, unit price, and category for each item that has a unit price…

A: Task 18: ALL Operator: The operator is used with WHERE or HAVING clause. If ALL operator is used in…

Concept explainers

Single Table

In a database management system, a single table is designed to obtain data of heterogeneous items. A single-table design with DynamoDB resolves the issue of raising multiple requests for the relevant data of an entity.

Question

Refer to the dimension tables and EmployeeFact table below.
Job
Date
Location
EmployeeFact
•JobID
•DatelD
•LocationID
• ( OEmployeelD
Title
FullDate
StreetAddress
oJobID
JobCode
DayNumber
City
PostalCode
OLocationID
LevelCode
MonthNumber
oHireDatelD
OBirthDatelD )
SalaryAmount
BonusAmount
MonthName
State
Year
CountryCode
EducationYears
PerformanceRating
The following query reports the employee with the highest salary amount per postal code
for employees with level code 8. Complete the missing values.
SELECT CountryCode, EmployeeID, MAX(_
_(A)_
FROM
(B).
Location, Job
WHERE EmployeeFact.LocationID = Location.LocationID
AND EmployeeFact.JobID =
(C).
AND
= 8
GROUP
(A) Ex: Identifier
(B)
(C)

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

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.
Based on the given table. Customer ID Name Balance Payment 193 Chen 2100 300 584 Ravindran 5000 250 231 Bolt 300 20 608 Gomez 950 125 What values are returned while the given query is executed? SELECT 2* (Balance - Payment) FROM Customer; 3900, 9750, 590, 1775 3600 3600, 9500, 560, 1650
CREATE TABLE sales ( SalesNumber INT(10) AUTO_INCREMENT PRIMARY KEY, SalesDate DATE, SalesTotal DECIMAL(10,2)); CREATE TABLE products ( number INT(11) AUTO_INCREMENT PRIMARY KEY, prodid VARCHAR(20) UNIQUE, prodname VARCHAR(30), price DECIMAL(10,2), onhand INT(11), CONSTRAINT fk_salesdetails_products FOREIGN KEY (prodid) REFERENCES salesdetails(prodid) ON DELETE RESTRICT); CREATE TABLE salesdetails ( number INT(10) AUTO_INCREMENT PRIMARY KEY, SalesNumber INT(10), prodid VARCHAR(20), price DECIMAL(7,2), qty INT(10), CONSTRAINT fk_salesdetails_sales FOREIGN KEY (SalesNumber) REFERENCES sales(SalesNumber) ON DELETE CASCADE, CONSTRAINT fk_salesdetails_products FOREIGN KEY (prodid) REFERENCES products(prodid) ON DELETE CASCADE); Using the above SQL and the schema diagram, create an ER diagram detailing all the fields of the tables and the relationship amount the tables.
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.
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 table named company with these columns: Company_id varchar(255) Company_name varchar(255) default ‘x’ Hq_phone_number varchar(255) Primary key of company_id (please use constraint format) Unique key of Hq_phone_number (please use constraint format)
Create a query to find the balance characteristics for all customers, including the total of the outstanding balances. The results of this query are shown in Figure P7.22. make sure the decimal are the same
Create a View to show the city name of any location that has a department. Only show the city name once in the results. You must use a non-correlated subquery.Call this view: Department_LocationsInclude a second query to display from the View after it is created. Refer to the attached for the table.
using the code below write a query to display the minimum balance, maximum balance, and average balance for memberships that have a rental CREATE TABLE MEMBERSHIP ( MEM_NUM NUMBER(8,0) PRIMARY KEY, MEM_FNAME VARCHAR2(30) NOT NULL, MEM_LNAME VARCHAR2(30) NOT NULL, MEM_STREET VARCHAR2(120), MEM_CITY VARCHAR2(50), MEM_STATE CHAR(2), MEM_ZIP CHAR(5), MEM_BALANCE NUMBER(10,2) ); CREATE TABLE RENTAL ( RENT_NUM NUMBER(8,0) PRIMARY KEY, RENT_DATE DATE DEFAULT SYSDATE, MEM_NUM NUMBER(8,0) CONSTRAINT RENTAL_MEM_NUM_FK REFERENCES MEMBERSHIP ); INSERT INTO MEMBERSHIP VALUES (102, 'TAMI', 'DAWSON', '2632 TAKLI CIRCLE', 'NORENE', 'TN', '37136', 11); INSERT INTO MEMBERSHIP VALUES (103, 'CURT', 'KNIGHT', '4025 CORNELL COURT', 'FLATGAP', 'KY', '41219', 6); INSERT INTO MEMBERSHIP VALUES (104, 'JAMAL', 'MELENDEZ', '788 EAST 145TH AVENUE', 'QUEBECK', 'TN', '38579', 0); INSERT INTO MEMBERSHIP VALUES (105, 'IVA',…
Insert a row into the LARGE_PROPERTY table for a new property. The office number is 1, The address is 2643 Lugsi Dr., The number of bedrooms is 3, The number of floors is 2, The monthly rent is $775, The owner number is MA111. Make sure to include the period (.) in the address.
use the following picture to answer question below question 10 Insert below record to the Customer table. Assuming there is a Default Constraint on the City column, insert default value of Default Constraint. Insert Null values for State and Phone columns. CustID: 180 LName: Pourhadi FName: Farhad