Question: 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

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 range of 50000.00 $ and 200000$.

3- Write a SQL statement that shows customers that are not from the USA.

Table of Employees:

4- Write a SQL statement the shows the list of employees that their job title is Sales Rep.

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 OM.

10- Write a SQL statement the shows the list of payments that are not in the range of 4000 and 15000.

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!