Computer Science

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

SQL Queries

7 Likes

Answer

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

Answered By

4 Likes

Related Questions

Write a query to display the name of employee whose name contains 'T' as the last alphabet.
View Answer Bookmark Now

Write a query to display the name of employee whose name contains 'M' as first alphabet 'L' as third alphabet.
View Answer Bookmark Now
Write a query that selects all orders (Order table) except those with zeros or NULLs in the amt field.
View Answer Bookmark Now

Write SQL commands for the following on the basis of given table STUDENT :
Table : STUDENT
StudentNo. Class Name GAME Grade1 SUPW Grade2
10 7 Sameer Cricket B Photography A
11 8 Sujit Tennis A Gardening C
12 7 Kamal Swimming B Photography B
13 7 Veena Tennis C Cooking A
14 9 Archana Basket Ball A Literature A
15 10 Arpit Cricket A Gardening C
Display the names of the students who are getting a grade 'C' in either GAME or SUPW.
Display the different games offered in the school.
Display the SUPW taken up by the students, whose name starts with 'A'.

View Answer Bookmark Now