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.
Write a query to display the name of employee whose name contains 'M' as first alphabet 'L' as third alphabet.
Write a query that selects all orders (Order table) except those with zeros or NULLs in the amt field.
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'.