SQL Exercises, Practice, Solution - Using Boolean and Relational operators

SQL [12 exercises with solution]

1. From the following table, write a SQL query to find the details of the customers who have a gradevalue above 100. Return customer_id, cust_name, city, grade, and salesman_id.   Go to the editor

Sample table: customer

Click me to see the solution with pictorial presentation

2. From the following table, write a SQL query to find all the customers in ‘New York’ city who have a grade value above 100. Return customer_id, cust_name, city, grade, and salesman_id.    Go to the editor

Sample table: customer

Click me to see the solution with pictorial presentation

3. From the following table, write a SQL query to find the customers who belong to either the city ‘New York’ or have a grade above 100. Return customer_id, cust_name, city, grade, and salesman_id.    Go to the editor

Sample table: customer

Click me to see the solution with pictorial presentation

4. From the following table, write a SQL query to find the customers who belong to either the city ‘New York’ or not have a grade above 100. Return customer_id, cust_name, city, grade, and salesman_id.    Go to the editor

Sample table: customer

Click me to see the solution with pictorial presentation

5. From the following table, write a SQL query to find those customers who belong to neither the ‘New York’ city nor their grade value exceeds 100. Return customer_id, cust_name, city, grade, and salesman_id.    Go to the editor

Sample table: customer

Click me to see the solution with pictorial presentation

6. From the following table, write a SQL query to find details of all order excluding combination of ord_date equal to '2012-09-10' and salesman_id higher than 5005 or purch_amt greater than 1000. Return ord_no, purch_amt, ord_date, customer_id and salesman_id.   Go to the editor

Sample table : orders

Click me to see the solution with pictorial presentation

7. From the following table, write a SQL query to find the details of those salespeople whose commissions range from 0.10 to0.12. Return salesman_id, name, city, and commission.  Go to the editor

Sample table : salesman

Click me to see the solution with pictorial presentation

8. From the following table, write a SQL query to find details of all order where purchase amount less than 200 or excluding combination of order date greater than or equal to '2012-02-10' and customer ID less than 3009. Return ord_no, purch_amt, ord_date, customer_id and salesman_id. Go to the editor

Sample table : orders

Click me to see the solution with pictorial presentation

9. From the following table, write a SQL query to find all orders subject to following conditions. Exclude combination of order date equal to '2012-08-17' or customer ID higher than 3005 and purchase amount less than 1000.  Go to the editor

Sample table : orders

Click me to see the solution with pictorial presentation

10. Write a SQL query to display order number, purchase amount, achieved, the unachieved percentage for those order which exceeds the 50% of the target value of 6000.   Go to the editor

Sample table: orders

Click me to see the solution with pictorial presentation

11. From the following table, write a SQL query to find the details of all employees whose last name is ‘Dosni’ or ‘Mardy’. Return emp_idno, emp_fname, emp_lname, and emp_dept.    Go to the editor

Sample table : emp_details

Click me to see the solution with result

12. From the following table, write a SQL query to find the employees who works at depart 47 or 63. Return emp_idno, emp_fname, emp_lname, and emp_dept.    Go to the editor

Sample table : emp_details

Click me to see the solution with result

Practice Online

More to Come !

Query visualizations are generated using Postgres Explain Visualizer (pev).

Do not submit any solution of the above exercises at here, if you want to contribute go to the appropriate exercise page.