Question 4Fill in the blank: Aliasing involves _____ naming a table or column to make a query easier to read and write.

Alter building(Add Column)Write a query to add new column "description" of type varchar(255) add not null constraint to building table.

Write a query to change the datatype of the column starttime to datetime in the table 'bookings' and make it as Not null column

Write a query to modify the datatype of the column departmentId from VARCHAR(30) to INT in the table 'department'.Refer to the existing table DLL given below:

Create a query to update the membercost column to 1000 in the facilities table where the value of monthlymaintenance is greater than 500.

Fill in the blank: A SQL clause containing HAVING adds a _____ to a query instead of the underlying table.1 pointsubqueryfilterlimitjoin