CREATE TABLE Students (
StudentID INT PRIMARY KEY,
Name VARCHAR(50),
Grade INT,
Major VARCHAR(50)
);
CREATE TABLE CareerInterests (
InterestID INT PRIMARY KEY,
StudentID INT,
Interest VARCHAR(100),
SkillLevel INT,
FOREIGN KEY (StudentID) REFERENCES Students(StudentID)
);
import sqlite3
conn = sqlite3.connect('student_management.db')
cursor = conn.cursor()
cursor.execute("""
SELECT CareerInterests.Interest, COUNT(*) AS Count
FROM CareerInterests
JOIN Students ON CareerInterests.StudentID = Students.StudentID
WHERE Students.Major = 'Computer Science'
GROUP BY CareerInterests.Interest
ORDER BY Count DESC LIMIT 5;
""")
popular_careers = cursor.fetchall()
print("Popular Careers in Computer Science:")
for career in popular_careers:
print(f"{career[0]}: {career[1]}")
conn.close()