Coforge Interview Question

basic sql queries followed by pl/sql.