i want the answer of this databse qoustionplease dont answer until u will answer it correctly because im gonna give feedback weather like or dislike Given the table: emp [eid, ename, salary, d_id]The following sql statement retrieves:select max(sum(salary))from empgroup by d_id;Select one:O a. max salary of each department - retrieve only one valueO b. maximum sum of salaries of the departments in the company - retrieve one valueO c. sum of salaries of all departments - retrieve several valuesO d. maximum salary of all departments - retrieve several values

Here the query is select max(sum(salary) from emp group by d_id; From here it can be confirmed…

Answered: Given the table: emp [eid, ename,…

Engineering

Computer Science

Given the table: emp [eid, ename, salary, d_id] The following sql statement retrieves:

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

Consider the following schema and write SQL query for given statements. Student ( regNo, sName, sCity, sCGPA, sAge)Course ( cCode, cName, credit_hours)Enrollment (regNo, cCode, semester,quality_points,Grade) 1- Display 2nd row of Student table using Cursors. 2- Display all records of Enrollment table which are placed at even rows. 3- Execute given query in SQL and do as directed.a) UPDATE STUDENT SET ECITY = ‘ISB’ WHERE EID>101b) Count how many records have been updated in above query using cursor. 4- Write a mechanism which must not allow user to delete more than 1 records using cursor and transaction.
For the following Relational Algebra / SQL statements, specify the output of each query. (do not explain how each query will be executed, but specify the output to be obtained when the query is executed). (c) R1: ACTORS WHERE YearOfBirth < 1940 OR Gender = 'female' R2(SSNo, FName, LName): R1 [ SSNo, FName, LName ] R3: R2 NATURAL-JOIN ACTEDIN OVER SSNo C: R3 [ LName, Character ] (d) SELECT A1.FName, A1.LName, A1.YearOfBirth FROM ACTORS A1, ACTORS A2 WHERE A1.YearOfBirth = A2.YearOfBirth AND A1.SSNo != A2.SSNo (e) R1: ACTEDIN [ FilmNo, SSNo ] R2: FILMS WHERE FilmTitle = 'Unforgiven' [ FilmNo ] R3: ACTEDIN NATURAL-JOIN R2 OVER FilmNo [ SSNo ] R4: ACTORS NATURAL-JOIN R3 OVER SSNo [ SSNo, FName, LName ] R5: ( R1.SSNo ÷ R4.SSNo ) [ FilmNo ] C: ACTEDIN NATURAL-JOIN R5 OVER FilmNo [ FilmTitle ] (f) SELECT A.FName, A.LName, COUNT(*) FROM ACTORS A, ACTEDIN AI WHERE A.SSNo = AI.SSNo GROUP BY A.SSNo, A.FName, A.LName HAVING count(*) > 2 OR count(*) = 0
Consider the following tables. Primary keys are identified after each table. Hotel(Hnum,HName,Location) PK = HNum Room(RNum,HNum,Type,View,Price) PK = RNUM , HNum Booking(id,HNum,GNum,RNum,DateFrom,DateTo) PK = id Guest(GNum,Fname,Lname,Gender,DOB,City) PK = GNum Write SQL queries AND Relational algebra expressions (using the relational algebra operators: ρ, σ, π, , υ, ∩, sum, avg, count) for each of the following queries a) List all information about the rooms that have a price below the average price of all single rooms b) For each Hotel, List the total number of rooms c) List the names of hotels that have no booking in them d) List the first name and last name of Parisian guests who book a double room in Paris PLEASE ANSWER THE QUESTION BY WRITING SQL QUERIES AND RELATIONAL ALGEBRA EXPRESSION. Thank you.
Consider the following two tables: Draw three tables that can result by executing each of the following SQL statements. . 1. SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount FROM Customers AS c INNER JOIN Orders AS o ON c. customerID = o. customerID; 2. SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount FROM Customers AS c LEFT OUTER JOIN Orders AS o ON c. customerID = o. customerID; 3. SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount FROM Customers AS c RIGHT OUTER JOIN Orders AS o ON c. customerID = o. customerID;
Using SQL answer the following or how would I answer something similar. Create a temporary table T for diagnoses_icd, such that only the first three characters of the diagnosis code are preserved. Subsequently, count the number of unique diagnoses in T count the number of unique diagnoses for each animal patient in T Repeat 1 entirely, except the first three digits in every diagnosis should be preserved (in addition to any letters) and saved in a temporary table T1. E.g., for code ‘S4001’ preserve ‘S400’; for ‘0456’ preserve ‘045’. Use T1 created in 2. Count animal patients diagnosed for each ICD code* and list the top 10 most common diagnoses. *Do not count a animal patient more than once for each ICD
Provide SQL queries for tables: employees, departments,1. List the following details of each employee: employee number, last name, first name and salary.2. List employees who were hired in 1988.3. List the manager of each department with the following information:department number, department name, the manager's employee number,last name, first name, and start employment date.4. List all employees whose first name is "John" and whose last names begin with "B."5. List all employees in the Marketing department, including their employee number, last name, firstname, and salary.
Write a SQL query that retrieves the names and email addresses of all students who are enrolled in at least one course in the "Computer Science" department and have a graduation year of 2022 or later. Include the course name and instructor name for each enrollment in the output. Schemas of the tables are below. "students" table: student_id: unique identifier for the student name: name of the student email: email address of the student major: field of study for the student graduation_year: expected year of graduation for the student "courses" table: course_id: unique identifier for the course course_name: name of the course instructor_name: name of the instructor teaching the course. department: department offering the course. course_description: description of the course "enrollments" table: enrollment_id: unique identifier for the enrollment student_id: identifier for the student enrolled in the course. course_id: identifier for the course the student is enrolled in…
Write a SQL query that retrieves the names and email addresses of all students who are enrolled in at least one course in the "Computer Science" department and have a graduation year of 2022 or later. Include the course name and instructor name for each enrollment in the output. Schemas of the tables are below. "students" table: student_id: unique identifier for the student name: name of the student email: email address of the student major: field of study for the student graduation_year: expected year of graduation for the student "courses" table: course_id: unique identifier for the course course_name: name of the course instructor_name: name of the instructor teaching the course. department: department offering the course. course_description: description of the course "enrollments" table: enrollment_id: unique identifier for the enrollment student_id: identifier for the student enrolled in the course. course_id: identifier for the course the student is enrolled in…
Give the query graph of the following query, expressed in SQL; SELECT T_NAME, S_NAME FROM TEACHER, COURSE, STUDENT WHERE credit_hour=3 AND TEACHER.TNO= COURSE.CNO AND STUDENT.CNO = COURSE.CNO
For both stocks AMZN and FB, on what date (YYYY-MM-DDD) did they reach out their highest and lowest value.Provide the SQL script used to obtain the answer
From the Salesman and Customer tables below, write SQL statements to do the following: List the salesman id, rating and names of those salesmen who get rating from 3 to 5, sorted DESCENDING by rating. List all the customers’ information whose name starts with ‘F’ and the fourth character is ‘I’, rests may be any character. List the name and country of those customers and salesmen who belongs to the same country. Salesman table: Customer table:
can you help me iwth these two queries in mySQL. Write a SQL statement to create a table job_history including columns employee_id, start_date, end_date, job_id and department_id and make sure that, the employee_id column does not contain any duplicate value at the time of insertion and the foreign key column job_id contain only those values which are exists in the jobs table. Write a SQL statement to create a table employees including columns employee_id, first_name, last_name, email, phone_number hire_date, job_id, salary, commission, manager_id and department_id and make sure that, the employee_id column does not contain any duplicate value at the time of insertion and the foreign key columns combined by department_id and manager_id columns contain only those unique combination values, which combinations are exists in the departments table.