Changed sql query to static and added course stuff