Problem 4Select all employee's name and bonus whose bonus is < 1000.Table:Employee| empld | name| supervisor| salary |+-| John| 3| Dan| 3| Brad| null| Thomas | 3| 1000 || 2000 || 4000 || 4000 || 1| 2| 3| 4+---------+-empld is the primary key column for this table.Table: Bonus| empld | bonus |+-| 500 I| 2000 |1214-+---------+empld is the primary key column for this table.Example ouput:+----| name | bonus |+-----------+| John | null| Dan| 500 || Brad | null ||+.

Problem 4 Select all employee's name and bonus whose bonus is < 1000. Table:Employee | empld | name | supervisor| salary | | 3 | Dan | 1 | 2 | 3 | 1000 | | 2000 | | 4000 | | 4000 | | John | 3 | Brad I null | Thomas | 3 4 -----+ empld is the primary key column for this table. Table: Bonus || empld | bonus | | 2 | 500 I | 4 | 2000 | empld is the primary key column for this table. Example ouput | name | bonus || || John | null | | Dan | 500 I | Brad | null |

Problem 4 Select all employee's name and bonus whose bonus is < 1000. Table:Employee | empld | name | supervisor| salary | | 3 | Dan | 1 | 2 | 3 | 1000 | | 2000 | | 4000 | | 4000 | | John | 3 | Brad I null | Thomas | 3 4 -----+ empld is the primary key column for this table. Table: Bonus || empld | bonus | | 2 | 500 I | 4 | 2000 | empld is the primary key column for this table. Example ouput | name | bonus || || John | null | | Dan | 500 I | Brad | null |

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

SQL code for: (1) Hint: A NULL in the hours column should be considered as zero hours. Find the ssn, lname, and the total number of hours worked on projects for every employee whose total is less than 40 hours. Sort the result by lname */ /* (2) For every project that has more than 2 employees working on it: Find the project number, project name, number of employees working on it, and the total number of hours worked by all employees on that project. Sort the results by project number. /* (3) For every employee who has the highest salary in their department: Find the dno, ssn, lname, and salary. Sort the results by department number. */ /* (4) For every employee who does not work on any project that is located in Houston: Find the ssn and lname. Sort the results by lname /* (5) Hint: This is a DIVISION query For every employee who works on every project that is located in Stafford: Find the ssn and lname. Sort the results by lname */
SQL
Please refer to the following diagram for Q19 to Q20. PERSON PK P_ID P_LNAME P_FNAME ΕMPLOYΕ P_ID EMP_HIRE_DATE STUDENT P ID STUDY ΜAIOR PK, FK1 PK, FK1 19. Which of the following statements is/are true? (1) A Person must be either a Student or an Employee. (2) A Person can neither be a Student nor an Employee. (3) A Person must be a Student or an Employee or both. a. (1) only b. (3) only c. (1) and (2) only d. (1), (2) and (3).
Task 2: ' The Driver Relationship team wants to ensure that the all driving license IDs in the active drivers table have the length of 7. Alter the ACTIVE_DRIVERS table created in Chapter 8, Activity 1 to check the length of the DRIVER_DRIVING_LICENSE_ID.
Find the number of employees hired in January of all years
Consider the Employees table below to solve the following questions. Emp_ld First_name Last_name Salary Overtime Manager_ld 500 Anil Kathreena 18 16 10 Ramon 320 11 Alven 12 Нaydi Lowes 400 18 13 14 Norina Smith 600 500 17 Frid Bob 18 15 Mark Jone 450 210 16 16 Better Jake 900 Robert Santosh 17 Arnil 550 420 16 18 Mark 650 |17 1- Write SQL Query to list all employee details for all employees who have a salary of more than 500. Then, order the result by manager id in Descending Order. 2- Write an SQL Command to list all employees first names who do not have overtime.
• Write a simple stored function that Takes a gender as an input ● Find the staff whose gender matches the input Return the results Write a simple stored procedure that Takes a gender as an input Find the staff whose gender matches the input • Print the results
Based on Figure (a), which of the following statement is TRUE? STAFF staff_ID {pk} staff_name phone email { optional, or } HR SALES R&D HR_focus commission_rate product_focus research_exp research_area Figure (a) O A. R&D staffs will not have the basic information (i.e.: id, name, phone, and email) B. A HR staff cannot be a Sales staff or R&D staff at the same time. O C. A staff can be a HR staff and Sales staff at the same time. O D. All the staffs are categorized into three subclasses.
Question 3 refers to two data tables giving the details of a company's employees and company's job titles, called EMP and JOB respectively, which have the following format: Table EMP Column name Column type Integer Up to 10 characters Example entry Description Employee ID number Employee surname EMPNO 7369 ΕΝΑΜΕ SMITH Integer Integer Employee's job title No ID no. of employee's JOBNO 10 MGR 7566 manager Date employment started Monthly salary HIREDATE Date 17/12/1980 SAL Integer 1600 Table JOB Column type Integer Up to 15 characters Column name Example entry Description job title No Employee's job title JOBNO 10 JOB TITLE SALESMAN b) Using EMP and JOB tables, give an example of the JOIN SQL statement which uses "WHERE", "GROUP BY", “HAVING" and “ORDER BY" clauses. Explain the result table of the SQL statement. (Maximum 300 words).
Explain what the following R code does. 1 sales_grouped <- group_by (house_data, suburb, sale_month) sales_summary <- summarise (sales_grouped, 2 median=median (price), mean=mean (price)) arrange (sales_summary, suburb, sale_month) 3 4 5 (a) Line 1: Comment (b) Lines 2, 3 and 4: Comment (c) Line 5: Comment