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

Similar questions

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
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.
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)
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
Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104.
Display the total number of credits earned in each year using the tot credits (year, num credits) view.
Create a report of employees within the Research department showing First Name, Last Name, sorted alphabetically A-Z.
Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.
help please Create a table named BRANCH. The table has the following structureBRANCH_NUM decimal(2,0) NOT NULL default '0'BRANCH_NAME char(50) default NULLBRANCH_LOCATION char(50) default NULLNUM_EMPLOYEES decimal(2,0) deault NULL PRIMARY KEY (`BRANCH_NUM`) (Please type answer no write by hand)
5. Which orders were placed on or before April 1, 2009? List each order number and orderdate. Write this query in two different ways.