You are working with a database that contains a table named 'members.'Write a query to change the column name zipcode to pincode in the members table.Input format :The input tables are already prepopulated, as given in the problem statement.Output format :The output should display the column details after the alteration, showcasing the updated 'pincode' column in place of the original 'zipcode.'Refer to the sample output for the column headers.Sample test cases :Input 1 :Output 1 :COLUMN_NAMEmemidsurnamefirstnameaddresspincodetelephonerecommendedbyjoindate

Problem StatementYou are working with a database that contains a table named 'members.' Your task is to retrieve the column names of this table from the database's information schema. Additionally, there is a requirement to alter the data type of the 'zipcode' column in the 'members' table to 'int' and rename it as 'pincode.'Input format :The input tables are already prepopulated, as given in the problem statement.Output format :The output should display the column details after the alteration, showcasing the updated 'pincode' column in place of the original 'zipcode.'Sample Output 1COLUMN_NAMEaddressfirstnamejoindatememidpincoderecommendedbysurnametelephoneRefer to the sample output for the column headers.Sample test cases :Input 1 :Output 1 :COLUMN_NAMEaddressfirstnamejoindatememidpincoderecommendedbysurnametelephone

You have a table that was created with the following command:CREATE TABLE test ( primaryKey int NOT NULL AUTO_INCREMENT PRIMARY KEY, firstName varchar(30), lastName varchar(30), zipCode varchar(5))You need to create a new record in the test table with a first name of Jose, a last name of Federov, and a zip code of 12345. What statement should you enter?1 pointINSERT INTO test VALUES (‘Jose’, ‘Federov’, ‘12345’)INSERT INTO test VALUES (DEFAULT, ‘Jose’, ‘Federov’, ‘12345’)INSERT INTO test (primaryKey, firstName, lastName, zipCode) (DEFAULT, ‘Jose’, ‘Federov’, ‘12345’)INSERT INTO test (primaryKey, firstName, lastName, zipCode) (‘Jose’, ‘Federov’, ‘12345’)

Write a query to rename the table members to 'members_details'The required input tables are created in the back end.Input format :The input tables are already prepopulated, as given in the problem statement.Output format :The output should display the list of tables in the database to verify that the renaming was performed correctly.Refer to the sample output for the column headers.Sample test cases :Input 1 :Output 1 :Tables_in_ri_dbmembers_details

Write a query to rename table 'station' to 'station_details'.

Write a query to change the column name 'email_address' to 'email' in the building  table.Note:This query performs alter operation on building table. So ensure the table ‘building’ already created and exists in the database.If you get an error like ‘building’ does not exist. Then go back to first, third and fifth query and execute those create table query once and come back to this query.Column name to be altered and the new name must be specified without any mistake.If you specified wrong field name while altering the table, but if there is no syntax error then obviously the table will get altered but it will not get Accepted.In this case, alter the table with correct field names and get it Accepted.