Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 clarifyshow which SQL statement is the answer to which question. The questions are:
Table of Customers:
Write a SQL statement that shows customers that are coming from the USA, France, and Norway.
Write a SQL statement that shows customers that their credit limit is in the range of $ and $
Write a SQL statement that shows customers that are not from the USA.
Table of Employees:
Write a SQL statement the shows the list of employees that their job title is Sales Rep.
Write a SQL statement the shows the list of employees that their first name either has four letters or less or starts by D
Write a SQL statement the shows the list of employees that they report to either employeeNumber or
Table of Products:
Write a SQL statement the shows the list of products that their productScale is one of the following values ::::
Write a SQL statement the shows the list of products that their name has Honda, or Porsche, Benz or Ford.
Table of Payments:
Write a SQL statement the shows the list of payments where checkNumber starts with HQ or OM
Write a SQL statement the shows the list of payments that are not in the range of and
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started