SQL Assignment - 06

                                              Assignment - 06

-------------------------

Write SQL Queries for the following (based on the above data). You can use SQL Server Management Studio to run your queries:

  1. How many flats are there whose areaSqft is less than the 1200.
  2. How may floors exists in flatMaster table
  3. Can you figure out how many 2 BHK flats are there in the apartment?
  4. How may 3 BHK flats are there in block B?
  5. Display the smallest size of 3 BHK flat 
  6. Find , how many residents are there who have non gmail email account?
  7. How many maids are there who actually know cooking
  8. How many male maids are there who can also do cooking ?
  9. How many maids are there who have got "Good Behaviour" and comments by residents?
  10. Who is/are the highest ratings maids
  11. Can you figure out the each maid's years of experience todate?

Comments

Post a Comment