I want someone to urgently create a database and solve this and send me log and SQL file
State government want to keep record of engineering colleges in the state and the different streams they are offering (like computer, entc, civil), count of students in each stream, number of students paying full fees and number of students who have given fee concision. Create database enter data and solve following queries.
1. List names of colleges who are having more than 50 students in civil department
2. List names of colleges with streams and total number of students in that stream who are having more number of students with fee concision.
3. List names of colleges who are having more than 500 students considering total of all the streams.