Answer Happy

1. List all those customers that live not in paris and in london, in descending order of their name. (2 Minutes)
2. List all those customers who have not 'Alti' in their name and are neither from London, Paris or NewYork. (Note: you are not allow to use OR operator) (5 Minutes)
3. List all those customers who are neither from London nor New York. (2 Minutes)
4. List those orders whose purchase amount is not greater than 500 or less then 2000.
(2 Minutes)
5. List all salesmen whose second last character in their name contain ‘_’. (5 Minutes)
6. List all orders in ascending order of their order date. (2 Minutes)
7. Get the first name of all salesmen and change the column name from name to firstName. (5 Minutes)
8. List all the orders that were made before March(jan to feb). (5 Minutes)
9. Show those customersId who have made order in 2012 as well as 2015 and purch_amt greater than 1000. (5 Minutes)
10. Show those customersId who have made order in 2011 or in 2013. (5 Minutes)
11. Show those customersId who have made order not in 2012, 2013 but in 2014, 2015. (5 Minutes)