Question: Q1. Write the SQL statement to display the employee id, employee name and city of those employees whose designation is Manager and annual (yearly) commission

Q1. Write the SQL statement to display the employee id, employee name and city of those employees whose designation is “Manager” and annual (yearly) commission is greater than 4000. (hint: the given commission in table is monthly).

Q2.Write the SQL statement to display the employee ids, employee names, departments, cities and countries of those employees whose salary is in between 2000 and 3000.

Step by Step Solution

★★★★★

3.45 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

1 Select id name from employ... View full answer

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!

Q1. Write the SQL statement to display the ids, names, job names and salaries of all employees in descending order by minimum salary. Q2. Write the SQL statement to insert a new column named...

Write an SQL statement to display the SKU, SKU_Description, WarehouseID, WarehouseCity, and WarehouseState of all items not stored in the Atlanta, Bangor, or Chicago warehouse. Do not use the NOT IN...

Write an SQL statement to display WarehouseID.

Create new reports for Coast Jewelers a. Create and print a report for Coast Jewelers that lists the supplier ID, supplier name, and city from the supplier table. (Use the supplier table to locate...

How to make a parameterized stored procedure to display the department id, department name, and street addresses of those departments who belongs to the Japan. (Hint: inner join)

Using the NVL() function Create a SQL query that shows the customer address1, customer address 2, customer city, customer state and customer postal code from the CUSTOMERS table. Use the NVL()...

Your organization has decided to encourage employees to take courses by reimbursing each eligible employee a maximum of $3,500 in tuition and fees during any one calendar year. Anyone who wants to...

Write a query to display the employee number, last name, e-mail address, title, and department name of each employee whose job title ends in the word ASSOCIATE. Sort the output by department name and...

Write a query to display the customer code, first name, and last name of all customers who have had at least one invoice completed by employee 83649 and at least one invoice completed by employee...

Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw the same situation using the tool you have...

Earlier in the day, a manager resolved a conflict between one of their employees and a customer over poor service. The customer was dissatisfied with the service they received from the employee,...

Compute the matrix exponential e At for each system x' = Ax given in Problems 9 through 20. x' 1 = 9x 1 - 8x 2 , x' 2 = 6x 1 - 5x 2 Data in Problem 9 through 20 9. x = 5x14x2, x = 2x1-x2 x = 4x14x2...

An object $20 \mathrm{~mm}$ tall is placed $70 \mathrm{~mm}$ to the left of a converging lens that has a focal length of $100 \mathrm{~mm}$. (a) Draw a scale diagram showing the three principal...

A vertical centrifuge, operating at $100 \mathrm{rpm}$, contains an aqueous suspension of solid particles with $S G=1.3$ and radius of $1 \mathrm{~mm}$. When the particles are $10 \mathrm{~cm}$ from...

The rallying cry of Donald Trump in the US presidential election in 2016 was to Make America Great Again and to focus on policies that protected and boosted US jobs and US workers. On election, Mr...

Compute the variance and the ACF (lag-1 to lag-4) of the following ARMA models with $\operatorname{Var}\left(a_{t} ight)=1$ : (a) $z_{t}=0.7 z_{t-1}+a_{t}$; (b) $z_{t}=0.4 a_{t-1}+a_{t}$; (c)...

In Quick Books, when you use the Estimate icon, the amount of the estimate is recorded as: A. a debit to Accounts Receivable and credit to Sales Revenue in the general ledger B. no entry is recorded...

1) The government decided to reduce taxes on fast-food to increase revenue. The government assumes that fast-food products have a) An inelastic demand b) An elastic demand c) A demand curve that is...

Explain why INSTEAD OF triggers are needed for join views.

Under what conditions is the following SQL statement valid?

Explain how Java accomplishes portability.

The following data represent enrollment in a major at your university for the past six semesters (Note: semester 1 is the oldest data; semester 6 is the most recent data): Semester Enrollment 1.. 87...

A brokerage company is interested in forecasting the number of new accounts the office will obtain next month. It has collected the following data for the past 12 months: Month Accounts 1.19 2.20...

Refer to Problem 16-30. a. Use the linear trend model (without transformation) for the first 15 months and provide a cash balance forecast for month 16. Then make the t2 transformation and develop a...