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