Question 8Write a query on the customers table whose output will exclude all customers with a rating

Question

Question 8Write a query on the customers table whose output will exclude all customers with a rating <= 100, unless they are located in Shimla.

Accepted Answer

SELECT *
FROM customers
WHERE rating > 100 OR city = 'Shimla' ;

Simple Queries in SQL — Question 8