Answered step by step
Verified Expert Solution
Link Copied!

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Administrator Limited Edition

Authors: Martif Way

1st Edition

B0CGG89N8Z

More Books

Students also viewed these Databases questions

Question

What are the Five Phases of SDLC? Explain each briefly.

Answered: 1 week ago

Question

How can Change Control Procedures manage Project Creep?

Answered: 1 week ago