SQL Queries - Assignment

Assignment 2

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

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 two features here. [1]. use of aliases [2]. use of DISTINCT keyword.

Select (display) all the details of all the residents
Select (display) floor numbers from the flatMaster table. (What are all the flats?)
Select (display) residentName, phone and email of all the residents
Select (display) all the flat details.
Select (display) resident's Name, Date of Birth and flat they belong to
Select (display) residentName as (Resident Name), DOB as (Date Of Birth) , flatNo (Flat Residing In)
Display unique floors
Display unique blocks
What are all distinct size of flats available
Select (display) all users names with their respective passwords
Select (display) all the maid/househelp details with their experience
Select (display) all the maid names and the flat they are working in
Select (Display) all the unique maid/househelp names

CodeWithAbby