SQL Queries - Assignment

Assignment 3

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

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

Hint/Note : You will be using three features here. [1]. WHERE Clause [2]. Like Keyword and [3]. Operators in SQL

Select (Display) all the flats belonging to 'A' Block.
Select (Display) all the 3rd floor flats
Select (Display) all the active users
Select (Display) all the residents whose names start with English letter 'a' or 'A'
Select (Display) all the residents whose names end with English letter 'a' or 'A'
Select (Display) all the residents whose names second character English letter 'a' or 'A'
Select (Display) all the residents whose names third character English letter 'i'
Select (Display) all the residents whose names contain the word 'kumar'
Select (Display) all the residents whose names First character is 'a' and second character can be anything in [m,j]
Select (Display) all the residents whose names first character is 'a' but the second character is neither 'm' nor 'j' (but can be anything else)
select (Display) all the residents who have got gmail ID
Select (Display) all the residents who are tenants.
Select (Display) all the residents who belong to block "A"
Select (Display) all the residents whose birthday falls between January 1 1963 to December 31 2022.
Select (Display) all the maids who are no more working in the apartment society
Select (Display) all the male maids in the society
Select (Display) all the maids who does baby sitting.
Select (Display) the comments of all maids having ratings more than 3.
Select (Display) all the flates which are more than 1100 square feet.
Select (Display) all the flates of block "A" and "D"

CodeWithAbby