Question: Answer the following questions. Make sure you use comments in your SQL file to clarify / show which SQL statement is the answer to which

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:
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 Databases Questions!