Question: 3) using the (database) table represented on the other side/next page , (column headings in bold) write an SQL query to get all the names

3) using the (database) table represented on the other side/next page , (column headings in bold) write

an SQL query to get all the names of employees who have been employed more than 20 years and are

older than 70

Name EmployeeID Age NumberOfYears

John 10001 107 60

Enping 10002 29 5

Michael 10003 94 10

Seikyung 10004 93 30

Yiheng 10005 54 22

Haleh 10006 25 3

Janice 10007 40 20

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

PYTHON Name John Enping Michael Seikyung Yiheng Haleh Janice EmployeeID 10001 10002 10003 10004 10005 10006 Age 107 29 94 93 54 25 40 NumberOrYears 60 5 10 30 22 3 10007 20 3) using the database)...

Q:

1.Write one SQL statement to set up table MoSpo HallOfFame according to the following Relational Schema: MoSpo HallOfFame(hoFdriverId, hoFYear, hoFSeries, hoFImage, hoFWins, hoFBestRaceName,...

Q:

APPLICATION PROBLEM SET 3 Problem 3.1 Creating an Access Database Using an Excel File Each worksheet in the Company.xls file represents a different table in a simple company database. You are to use...

Q:

APPLICATION PROBLEM SET 3 Problem 3.1 Creating an Access Database Using an Excel File Each worksheet in the Company.xls file represents a different table in a simple company database. You are to use...

Q:

REQUIREMENT/ ASSIGNMENT QUESTION TASK 1 (DOCUMENTATION) The relational schema of a database below is about employees, their departments and the projects they work on: DEPARTMENT DeptNo, DeptName,...

Q:

TASK 1 (DOCUMENTATION) The relational schema of a database below is about employees, their departments and the projects they work on: DEPARTMENT DeptNo, DeptName, Location, NumOfStaff EMPLOYEE EmpNo,...

Q:

Problem Statement: You are asked to design a database called MOVIES that keep track of various data on movies, actors, roles in movies and famous quotes in movies. So far the following 5 tables...

Q:

For all the questions below write SQL query, Submit your queries in one pdf document. You only need to submit the query statement, no need to include resultset. The number at the end of the query...

Q:

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

Q:

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

Q:

John Harbeck is confused about computing physical units. Explain to John how physical units to be accounted for and physical units accounted for are determined.

Q:

A company decides to use the basic economic order quality model for a particular product. The Annual demand for the product is 2500 units the annual holding cost is $2 per unit and the cost of...

Q:

When equity - to - asset ( E 2 A ) is equal to zero, leverage ( D 2 E ) is equal to . . . Undefined 0 1 - 1 This is not enough information to answer It's a trap! These ratios don't depend on each...

Q:

Chamberlain Corp. is evaluating a project with the following cash flows. The company uses a discount rate of 11 percent and a reinvestment rate of 8 percent on all of its projects. Year Cash Flow 0 $...

Q:

9-10 In this exercise, youll use database software to develop an application that tracks customer service requests and analyzes customer data to identify customers meriting priority treatment. Prime...

Q:

9-13 Why did WIM feel the need to implement an ERP system? Welding Industries Malaysia (WIM) is the only local Malasian company that manufactures welding machines for commercial use. WIMs remarkable...

Q:

9-17 What are 3 reasons why a company would want to implement an enterprise resource planning (ERP) system and two reasons why it might not want to do so.