Cognizant Interview Question

SQL, Python like what is view what is having and where , write a query for group by function, what is the difference between array and list, what is self_init in python