Assignment $1$:

a$.$ Write a query to retrieve Visit$\_$ID$,$ Hospital$\_$ID$,$ the hospitals' name and city from the table Visits and Hospitals using Inner Join.

b$.$ How many records did you get in the output?

Assignment $2$:

a$.$ Write a query to retrieve Visit$\_$ID$,$ Hospital$\_$ID$,$ the hospitals' name and city from the table Visits and Hospitals using LEFT Join.

b$.$ How many records did you get in the output?

Assignment $3$:

a$.$ Write a query to retrieve Visit$\_$ID$,$ Hospital$\_$ID$,$ the hospitals' name and city from the table Visits and Hospitals using FULL Join.

b$.$ How many records did you get in the output?

Assignment $4$: write a query to count the number of visits of each hospitals using the Visits table.