SQL Queries - Assignment-5

Assignment - 5

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

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 the features here IN, BETWEEN & TOP

Select (Display) all the floor details for the ground , first and second floor
Select (Display) all the floor details except for the ground , first and second floor
Select (Display) all the floor details having area in square feet between 1000 to 1300
Select (Display) all the floor details having area in square feet NOT between 1000 to 1300
Select (Display) all the residents details who were born between 1970 to 1980
Select (Display) top 1 residents details
Select (Display) top 50% residents details
Select (Display) top 2 residents who resides in block 'A'
Select (Display) all residents whose name starts from letter 'A' - 'P'
Select (Display) all users whose credentials created between January 2021 to December 2022
Select (Display) how many residents are owners and tenants
Select (Display) the maids having average ratings more than 3
Diplay the blocks having number of residents more than 10
Diplay all the female maid details who can do baby sitting.
Diplay the maidID and Number Of Flats She/He has worked for those maids who have worked for more than 2 flats

CodeWithAbby