w3resource
SQL exercises

SQL: Using NOT, OR & AND operators

SQL Boolean Operator Statement : Exercise-9 with Solution.

Write a SQL statement where i) order dates are anything but 2012-08-17, or customer id is not greater than 3005 ii) and purchase amount is not below 1000.

Sample table : orders


Sample Solution :

SELECT * 
FROM  orders 
WHERE NOT((ord_date ='2012-08-17' 
OR customer_id>3005) 
AND purch_amt<1000);

Output of the Query:

ord_no	purch_amt	ord_date	customer_id	salesman_id
70009	270.65		2012-09-10	3001		5005
70002	65.26		2012-10-05	3002		5001
70005	2400.60		2012-07-27	3007		5001
70008	5760.00		2012-09-10	3002		5001
70010	1983.43		2012-10-10	3004		5006
70003	2480.40		2012-10-10	3009		5003
70013	3045.60		2012-04-25	3002		5001
70001	150.50		2012-10-05	3005		5002
70007	948.50		2012-09-10	3005		5002

Explanation :

Syntax of Display all reverse orders where order dates equal to a specified date or customer id greater than a specified number and purchase amount less than a specified amount

Pictorial presentation :

Result of Display all reverse orders where order dates equal to a specified date or customer id greater than a specified number and purchase amount less than a specified amount

Query Visualization:

Duration:

Query visualization of Using NOT, OR & AND operators - Duration

Rows:

Query visualization of Using NOT, OR & AND operators - Rows

Cost:

Query visualization of Using NOT, OR & AND operators - Cost

 

Practice Online


Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a SQL query to display all orders where purchase amount less than 200 or exclude those orders which order date is on or greater than 10th Feb,2012 and customer id is below 3009.
Next: Write a SQL query to display order number, purchase amount, achived, the unachieved percentage for those order which exceeds the 50% of the target value of 6000.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming