Question: 5- Write a SQL statement the shows the list of employees that their first name either has four letters or less or starts by D.

5- Write a SQL statement the shows the list of

5- Write a SQL statement the shows the list of employees that their first name either has four letters or less or starts by D. 6- Write a SQL statement the shows the list of employees that they report to either employeeNumber 1002, 1056, or 1076. Table of Products: 7- Write a SQL statement the shows the list of products that their productScale is one of the following values 1:18, 1:700, 1:50, 1:32. 8- Write a SQL statement the shows the list of products that their name has Honda, or Porsche, Benz or Ford. Table of Payments: 9- Write a SQL statement the shows the list of payments where checkNumber starts with HQ or . 10- Write a SQL statement the shows the list of payments that are not in the range of 4000 and 15000 SAMPLE DATABASE TABLE LIST customers employees offices orderdetails orders payments productlines products

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 General Management Questions!

Write a SQL statement that shows the list of employees that their first name either has four letters or less or starts by D .

write an sql statement that shows the list oc employees that their firstname either has four letters or less or starts by D - Write a SQL statement the shows the list of employees that their first...

6- Write a SQL statement the shows the list of employees that they report to either employeeNumber 1002 1056, or 1076 Table of Products: 7. Write a SQL statement the shows the list of products that...

Write a SQL statement to retrieve all columns from employees table with last name of 'abel', regardless whether the letters are in upper or lower cases. Write a SQL statement using employees table to...

SQL Use the CUSTOMER table and ORDERS table. Write a SQL statement to find the rep number, last name, and first name of each sales rep who represents at least one customer with a credit limit less...

Table of Customers: 1- Write a SQL statement that shows customers that are coming from the USA, France, and Norway 2- Write a SQL statement that shows customers that their credit limit is in the...

Table of Customers: 1- Write a SQL statement that shows customers that are coming from the USA, France, and Norway. 2- Write a SQL statement that shows customers that their credit limit is in the...

18. Write an SQL that will list the employees first name, and dependents first name and dependents birth date of all dependents who are less than 10 years old based on the date the query was run. 19....

I need all questions fast darabase sql oracle 1. 2. 3. 4. 5. 6. 7. 8. 9. Write an SQL query to fetch the list of employees with different salaries. Write an SQL query to show the second highest...

please solve this with sql thank you :) 1 1. Display the customer id, customer name, email address, and the phone number for all customers with the credit limit less than 200. Sort the result by...

Fast Growth Company just paid a dividend of $2 .15 per share. Dividends are expected to grow at a constant rate of 18% per year. If you require a 20 percent return on stocks in this risk class. What...

In the past, a large share of expatriate managers from the United States have returned home before successfully completing their foreign assignments. Suggest some possible reasons for the high...

What are the main determinants of productivity in an economy?

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...