7. Display the name and hire date of even- employee who was hired in 1982. ENAME HIREDATE SCOTT 09-DEC-82 MILLER 23-JAN-82 8. Display the name and job title of all employees who do not have a manager. ENAME JOB KING PRESIDENT 9. Display the name, salary, and commission for all employees who earn commissions. Sort data in descending order of salary and commissions. ΕΝΑΜΕ SAL COMM ALLEN 1600 300" TURNER 1500 MARTIN 1250 1400

7. Display the name and hire date of even- employee who was hired in 1982. ENAME HIREDATE SCOTT 09-DEC-82 MILLER 23-JAN-82 8. Display the name and job title of all employees who do not have a manager. ENAME JOB KING PRESIDENT 9. Display the name, salary, and commission for all employees who earn commissions. Sort data in descending order of salary and commissions. ΕΝΑΜΕ SAL COMM ALLEN 1600 300" TURNER 1500 MARTIN 1250 1400

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: 12. Report the names of the professors who supervise more than one student. 13. Report the names…

A: In order to find professors who supervise more than one student, we will need a COUNT() function on…

Q: Database design Objectives: To understand and be able to write simple SQL queries Instruction:…

A: select last_name, salary from employees where salary > xyz; select last_name, department_id…

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: Switch to the Melbourne Swim Teams In cell B14, use the INDEX function to display the value in the…

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

A: The given data samples have the details about a Customer in CUSTOMER table and corresponding orders…

Q: Based on the ERD below, display Employee first name, middle initial and last name so it displays in…

A: In this case, the whole name is displayed in a single column of employees where the job code is…

Q: Create a list manager names and also his supervise names if the manager has any one

A: you can try this query to get the result

Q: If the functional dependencies are consistent with the above relation, put TRUE. If they are not,…

A: functionally dependent defines the relationship between attributes, how they are related. A-> B…

Q: - Copy the name, salary, and commission of each employee hired before 1980 into TEMP table - Copy…

A: INSERT INTO query is used to copy the sql data from one table to another table.WHERE is SQL clause…

Q: 7. Create the following table : EMPLOYEE TAB Empid Empname 4 digits 50 Comm. Deptid 4 digits…

A: Queries are written by using MySQL database. 7. EMPLOYEE_TAB: CREATE TABLE EMPLOYEE_TAB(Empid INT(4)…

Q: Find the staff name who has the maximum salary for each branch Find the staff name who has the…

A: SQL is the Structured Query Language, which is the computer language for storing, manipulating and…

Q: View 3 Seneca Courses Inc. Employee Forms All employee information for SCI is maintained on file…

A: Actually, the answer has given below:

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition. student…

Q: Part II: Complete the following exercise: Using a subquery, select student first name where the…

A: As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…

Q: Check the following statement: select sysdate Today, (select count (*) from departments)…

A: Solution :

Q: 1. Retrieve the SSN_NUMBER of all employees whose name starts with N. Attribute First Name Last Name…

A: Given: Structure of a table employee is given having attributes First_Name, Last_Name, SSN_Number.…

Q: For each sale made on June 1, 2015, show the following information: CustomerID, Customer name…

A: Hey, since there are multiple questions posted, we will answer first question. If you want any…

Q: CUST_ID 78 CUST _ID 54 NAME YORK UNIVERSITY NAME SENECA COLLEGE LOCATION…

A: Given, CUST _ID NAME LOCATION SALES_REP 78 YORK UNIVERSITY NORTH YORK ANDRE MARTIN 54 SENECA…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: 5. In the OrderItems table, display a count of the number of products where item_price is greater…

A: Algorithm:From the OrderItems tableFrom the OrderItems tableWhere item_price is greater than or…

Concept explainers

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.

Question

7. Display the name and hire date of even- employee who was hired in 1982.
ENAME
HIREDATE
SCOTT
09-DEC-82
MILLER
23-JAN-82
8.
Display the name and job title of all employees who do not have a manager.
ENAME
JOB
KING
PRESIDENT
9. Display the name, salary, and commission for all employees who earn commissions. Sort
data in descending order of salary and commissions.
ENAME
SAL
COMM
ALLEN
1600
300"
1500
1250
TURNER
MARTIN
1400
WARD
1250
500

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

7. Show all item num from the item table, and a matching quoted price from the order line table (show blank if there is no matching quoted price).
Add the provided information to a new record in the REP table. SELECT * FROM REP Expected Results REP_ID FIRST_NAME LAST_NAME ADDRESS CITY STATE POSTAL CELL_PHONE COMMISSION RATE 35 Fred Kiser 427 Billings Dr. Cody WY 82414 307-555-6309 0.00 0.05
Access Assignment Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70…
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 */
write SQL statement to search for employees who is the manager of the department specified by the cboDept
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.
write SQL statement to search for employees whose manager is specified by the txtEname box
IF POSSIBLE PLEASE TYPE OR WRITE ELIGIBLY illustrate the process of normalizing the data shown in this table to third normal form (3NF). officeNo officeAddress telNo mgrStaffNo name B001 8 Jefferson Way, Portland, ME 97201 503-555-3618 S1500 Tom Daniels B002 City Center Plaza, Seattle, WA 98122 206-555-6756 S0010 Mary Martinez B003 14 – 8th Avenue, New York, NY 10012 212-371-3000 S0145 Art Peters B004 16 – 14th Avenue, Seattle, WA 98128 206-555-3131 S2250 Sally Stern Primary key: officeNo Why the above table is not in 3NF? Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF). c) Identify the primary and foreign keys in your 3NF relations.
Find the number of employees hired in January of all years
How many times has each language been used in films? Return the value for all six languages. Display: language name and the number of films
I need C please
#SQL Question Use TopBabyNamesbyState.csv1 and write queries to extract the following information: 4) How many unique names are there in this dataset? 5) Which name in which state and in which year had the highest number of occurrences. 6) What is the average occurrence of “Jessica” as a top name in the state of CA? 7) How many years was “Mary” the top name in California? Name the computed column as “Mary_topinCA”. 8) The three most popular female names in WA state since 2000. Popularity is based on the total number of occurrences. Report the names along with the total number of occurrences. 9) Make a list of names that have an average occurrence greater than 1000. Order the result table by name in an ascending alphabetical order.