insert into employee values (null,'Alice','f',23,'A12345','who',500,'Pune'); insert into employee values (null,'Alice','f',23,'A12345','who',500,'Pune'); ALTER TABLE ...
select count(*) as col_num from information_schema.columns where table_name='emp_details'; -- numeric and percenatge breakdown based on gender select gender,count ...