Question

8. Write a query on the customers table whose output will exclude all customers with a rating <= 100,
unless they are located in Shimla.
9. Write a query that selects all orders (Order table) except those with zeros or NULLs in the amt field.

​

Answer 1

8. first picture

9. second picture

Answer 2

SQL query

Explanation:

Query on the customers table whose output will exclude all customers with a rating <= 100

Select customerName  from customers where rating > 100 or  city like  ‘Shimla’;

where like matches the specified pattern

Query that selects all orders (Order table) except those with zeros or NULLs in the amt field

Select * from order where (amt is NOT NULL and amt <> 0);

where <>  defines  " not equal to"