5. Display the employee name and department number of all employees indepartments 10 and 30 in alphabetical order by name.ENAMEDEPTNOALLEN30BLAKE30CLARK10301030JAMESKINGMARTINMILLER10TURNER30WARD309 rowsselected6.Modify p2q3.sql to list the name and salary of employees who earn more than$1500 and are in department 10 or 30. Label the columns Employee and MonthlySalary, respectively. Resave your SQL statement to a file named p2q6.sql Rerunyour query.EmployeeMonthly SalaryKING5000BLAKE2850CLARK2450ALLEN1600

Before writing the query for the given condition we have to create the table and then we have to…

5. Display the employee name and department number of all employees in departments 10 and 30 in alphabetical order by name. ENAME DEPTNO ALLEN 30 BLAKE 30 CLARK 10 30 10 30 JAMES KING MARTIN MILLER 10 TURNER 30 WARD 30 9 rows selected

5. Display the employee name and department number of all employees in departments 10 and 30 in alphabetical order by name. ENAME DEPTNO ALLEN 30 BLAKE 30 CLARK 10 30 10 30 JAMES KING MARTIN MILLER 10 TURNER 30 WARD 30 9 rows selected

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: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

Q: Alter the INVOICE_LINE table by adding the INVOICE_NUM column as a foreign key referencing the…

A: Alter table : used to modify column, add column/columns, add constraints, drop column, rename, drop…

Q: Display the maximum price of all the products in PRODUCTS table for each Supplier ID having a…

A: Here we need to join Table Supplier and PID. Since they have common attribute,they can be joined…

Q: CREATE TABLE employees ( employee_number int NOT NULL, last_name char(50) NOT NULL, first_name…

A: Create table employee and insert given values to the table.

Q: Create a list showing only the EmployeeID, Sales, and Projected Sales sorted from highest to lowest…

A: The query selects the specified columns from the EmployeeSales table and orders the result set based…

Q: 1. Write an SQL query to find the CUSTOMERNAME who order the COMPUTERS. 2. Write an SQL query to…

A: It is defined as a Structured Query Language, is a programming language designed to manage data…

Q: Q6) how much is the total customer balance ? Q7) what is the minimum price for each sale code?

A: SQL QUERY: Select SUM(CUS_BALANCCE) AS [Sum of Balance] From Customer Group by CUS_CODE.

Q: List every column in the Condo_UNIT table and its associated typ

A: The, database is a used to stores the data.

Q: WEEK 1 ASSIGNMENT#2 Complete the following exercise: Create a student table. The student table…

A: CREATE TABLE student ( Student_ID int NOT NULL PRIMARY KEY, Student_First_Name varchar(20) NOT…

Q: Switch to the Melbourne Swim Teams In cell B14, use the INDEX function to display the value in the…

Q: write a query that displays employee last names, department numbers, and all the employees who work…

A: Here, SELECT statement is used along with the ON, WHERE, and ORDER BY clause.

Q: Q24) ?What product(s) have a price equal to the maximum product price Q25) List all employees with…

A: A relational database contains tables. Tables are also called relations and they contain rows and…

Q: True or False Each column in a table must have a name.

A: Each column in a table must have a unique name. The entries within each column should match with…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: Update the rent of PROPERTY_ID=1 to 1200 using the COLOMBIA_CITY_PROPERTY VIEW.

A: Answer to the above question is in step2.

Q: Q1) List the products that are supplied by a vendor

A: SQL command is used to create and manipulate data with the help of DDL (data definition language)…

Q: Task 6: Add the following record to the OWNER table: INSERT INTO OWNER VALUES('SA100', 'Sam',…

A: Attached the Procedure to add the following record to the OWNER table: INSERT INTO OWNER…

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: List the order number and order date for every order that was placed by Mary Nelson and that…

A: SQL, or Structured Query Language, is a programming language designed for managing and manipulating…

Q: 7) Write an SQL query to count how many account holders belong to each recurrent_acno

A: NOTE Below is the answer for the given question. Hope you understand it well. If you have any…

Q: _FNAME VARCHAR(15) NOT NULL, INITIAL CHAR(1), _AREACODE CHAR(3) DEFAULT '615' NOT N…

A: Given CREATE 'TABLE CUSTOMER CU S_CODE NUMBER PRIMARY KEY, CUS_LNAME VARCHAR( 1 5) NOT NULL,…

Q: department name information for those departments whose location_id is 1500

A: Attributes of Department Table are- department_id department_name employee_id location_id

Q: database HR Display the last name, salary, and commission for all employees who earn…

A: /* Creation of EMP table, I am creating column EMP_FIRST_NAME and EMP_LAST_NAME instead of…

Q: Add the OWNER_NUM column as a foreign key in the CONDO_UNIT table.

A: to Add the OWNER_NUM column as a foreign key in the CONDO_UNIT table, the script is mentioned in…

Q: write a mysql statement for following i) to show the structure of the table bike ii) to change the…

A: The language that is used to perform queries on a database is ‘structure query language’. It has…

Q: Q16) List the V_CODE and V_NAME of vendors that provide products Q8) List the product description,…

A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…

Q: Display the last_name of students table who have algebra_grades from 80 to 90,

A: i have answered this question in step-2.

Q: EMPLOYEE TABLE EMPLOYEE_ID FIRST_NAME SURNAME CONTACT NUMBER emp101 0877277521 emp102 emp103 emp104…

A: The queries for creating and inserting data to all tables are given below along with final OUTPUT…

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: Count the number of different professors names.

A: DISTINCT is the keyword used to get the different names and then COUNT is applied

Q: Task 17: List the invoice number and invoice date for each invoice that was created for James…

A: We need to provide a query that lists the invoice number and invoice date for each invoice that was…

Q: What is the proper way to insert this into my table? Insert into Vehicle values…

A: Given: A table Vehicle is created with attributes Vehicle_ID Vehicle_VIN Vehicle_Make…

Q: Task 7: Create a procedure to add a row to the INVOICES table. CALL ADD_INVOICE('00001',…

A: Attached handwritten Image of the procedure to add a row to the INVOICES table.

Q: Refer to the CREATE TABLE statement: CREATE TABLE Country ( ); Name VARCHAR (50), Population INT,…

A: The question is asking to complete an SQL INSERT INTO statement to add a new row into the 'Country'…

Q: The code: "SELECT SupplierlID FROM Products Order By SupplierName DESC;" extracts data from Products…

A: Sol1: Current procedure terminology (CPT) is a code such as reflex testing and is an integrated part…

Q: 2) Create a SELECT statement that returns the count, average, max and min of the invoices submitted…

A: SQL: SQL is defined as Standard Query Language it is mainly used for the manipulation of the…

Q: SUPPLIERS SID SNAME STYPE LOCATION 1 Lulu DS Salalah 2 C4 DS Saadah 3 Smile WS…

A: Here first we need to find SID of product 802. Let's name this as X. Then find productID and…

Q: Display Customer name (concatenate First Name and Last Name with a space between) and total number…

A: In order to concatenate the 'FNAME' with 'LNAME' use the '+' sign to combine them. Use the SELECT…

Q: Create a derived table which computes row number for employees in the USA partitioned by the…

A: Here, I have to write a solution for the above question.

Question

5. Display the employee name and department number of all employees in
departments 10 and 30 in alphabetical order by name.
ENAME
DEPTNO
ALLEN
30
BLAKE
30
CLARK
10
30
10
30
JAMES
KING
MARTIN
MILLER
10
TURNER
30
WARD
30
9 rows
selected
6.
Modify p2q3.sql to list the name and salary of employees who earn more than
$1500 and are in department 10 or 30. Label the columns Employee and Monthly
Salary, respectively. Resave your SQL statement to a file named p2q6.sql Rerun
your query.
Employee
Monthly Salary
KING
5000
BLAKE
2850
CLARK
2450
ALLEN
1600

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

find uniq data
q22
1. a) Create a table bank_master Column Name Datatype Varchar2(4) Varchar2(30) Varchar2(30) Number (7) b) Insert the records using the following table values Constraint accountno Not Null name address amount accountno name Address amount 101 Mohamed Burka 9000 102 Nasser Nizwa 8000 103 Khamiz Sohar 8200 104 Murshid Burka 7800 106 Mustasim Sohar 9500 a) Create a table bank_details Column Name Datatype Varchar2(4) number(4) date Constraint Recurrent_acno Not Null ac_no Transaction_date Fixed_deposit Number(8) b) Insert the records using the following table values Recurrent_acno | ac_no Transaction_date Fixed_deposit С101 101 12.05.2002 10000 C102 102 13.01.2020 80000 C103 103 14.02.2021 50000 C101 104 13.05.2020 40000 C102 105 15.06.2019 null
5. In the OrderItems table, display a count of the number of products where item_price is greater than or equal to $6, grouped by prod_id, but only for those groups having 3 or more of a given prod_id. Display the count with the alias shown. Sort by prod_id in ascending order. BRO3 1 rows returned in 0.03 seconds PROD ID Download 4 NUM PROD ID
Table: Employee EmpID 1 2 3 4 DeptID D01 D02 Name D03 Ronny Table: Department Kith John Anny Age HR 32 50 34 29 DeptName ADMIN Testing Deptal D D01 D03 D01 D02 Retrieve the Department names and the count of employees work in each Department, but only for department name with more than 2 employees work.
Find the staff name who has the maximum salary for each city.
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.
Alter the given table by adding new column of "Job" in it and assign the sequence values to the column AS WELL. EMPLOYEE ID LAST NAME 149 Zotkey 174 Abel 176 Taylor ANNSAL HIRE_DATE 126000 29-JAN-00 132000 11-MAY-96 103200 24-MAR-98 NOTE: ASSUME 100 RECORDS IN THE TABLE. YOU NEED TO CREATE PROCEDURE FOR IT. USE ANY LOOP TO FILL THE ENTERIES ALONG WITH DML OPERATION.
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)
SQL
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear