Question: 1. Write a query to display all customers with a grade above 100. 2. Write a query statement to display all customers in New York

 1. Write a query to display all customers with a grade

1. Write a query to display all customers with a grade above 100.

2. Write a query statement to display all customers in New York who have a grade value above 100.

3. Write a SQL statement to display all customers, who are either belongs to the city New York or had a grade above 100.

4. Write a SQL statement to display all the customers, who are either belongs to the city New York or not had a grade above 100. 5.Write a SQL query to display those customers who are neither belongs to the city New York nor grade value is more than 100.

above 100. 2. Write a query statement to display all customers in

6. Write a SQL statement to display either those orders which are not issued on date 2012-09-10 and issued by the salesman whose ID is 505 and below or those orders which purchase amount is 1000.00 and below

7. Display all in reverse, where order dates equal to a specified date or customer id greater than a specified number and purchase amount less than a specified amount.

8. Write a SQL query to display all orders where purchase amount less than a specified amount or order date and customer_id must not be greater than a specified data and less than a specified ID respectively

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!