Question: 1. Write a SQL query to show the first name and last names of employees that their position is secretary. 2. Write a SQL query

1. Write a SQL query to show the first name and last names of employees that their position is secretary.

2. Write a SQL query to show all the people who live in State,WA

3. Write a SQL to hwo the first name of all employess where their last name is Smith

4. Write a SQL query to show the first name, last name, and job category of people with salary between 50000-6000

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:

1. Write an SQL query to list customer first name, last name, customer code for customers who purchased any kind of saw. (hint: p_descript like *saw*). You need to join the Customer, Product, Vendor,...

Q:

1- Write an SQL query to show the age of each employee. 2- Write an SQL query to show the CustomerName and the complete address of each customer (the statement should return only two columns;...

Q:

Answer the following questions. Make sure you use comments in your SQL file to clarify/show which SQL statement is the answer to which question. The questions are: 1- Write an SQL query to show the...

Q:

Answer the following questions. Make sure you use comments in your SQL file to clarify / show which SQL statement is the answer to which question. The questions are: 1 . Write an SQL query to show...

Q:

1- Write an SQL query to show the birthdate and name of each employee. 2- Write an SQL query to show the CustomerName and the complete address of each custe (the statement should return only two...

Q:

homework. Answer the following questions. Make sure you use comments in your SQL file to clarify/show which SQL statement is the answer to which question. The questions are: 1- Write an SQL query to...

Q:

Answer the following questions. Make sure you use comments in your SQL file to clarify/show which SQL statement is the answer to which question. The questions are: 1- Write an SQL query to show the...

Q:

1- Write an SQL query to show the CustomerName and Country of Customers. 2- Write an SQL query to show all Countries (no duplicates), order them alphabetically. 3- Write an SQL query to show the...

Q:

1) Write a SQL query to show the country name where maximum number of movies has been produced, along with the number of movies produced. 2) Write a SQL query to show all the genre_id in one column...

Q:

please answer quick using hr.employees from oracle live sql 1. Write a query to display the name ( first name and last name ) for those employees who gets more salary than the employee whose ID is...

Q:

The embezzlement of funds from organizations is often orchestrated through fictitious accounts payable and related cash disbursement transactions. The AuditNet online resource center for auditors...

Q:

These data describe sales over time at a franchise outlet of a major US oil company. (The data fle has values for two stations. For this exercise, use only the 283 cases for site 1.) Each row...

Q:

Growing annuities Annuities are a series of constant cash flows that have been received over a certain period of time. However, not all annuities are created equal. Some annuities adjust the payments...

Q:

Video Excel Online Structured Activity: WACC and optimal capital budget Adamson Corporation is considering four average-risk projects with the following costs and rates of return; Project Expected...

Q:

Develop clear policy statements.

Q:

Draft a business plan.

Q:

Describe the guidelines for appropriate use of the direct plan.