Database Systems - SQL Exercises (6 Topics)
Note : Give an example of each data table
for each of the above topics
SQL EXERCISES Topic 1. Find employees who are over 50 years old and have an income of over 80,000 VND. Retrieval information includes: employee code, employee name; income_ Topic 2. Find department heads with more than 15 years of seniority as department heads. Displayed information includes: department head code, full name, date of birth. Topic 3. Find projects with more than 5 participants. Retrieval information includes project code, project name, number of participants. Topic 4. Export information of subjects with the highest number of retests_ Retrieval information includes: course code, course name Topic 5. Export information (faculty code, faculty name) of the faculties with the highest number of students_ Topic 6. Find students whose scores in the subject code 'MO1' are higher or equal to the average score of all students in the school also in this subject: The resulting information is a table with 2 columns: Student ID, Student's name, grade in subject 'MO1' , and average score of the whole school in subject 'MO1'