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
Get step-by-step solutions from verified subject matter experts
